I guess you have to find out the mappings yourself
If no one else have done it already.
Are you using the jdbc-odbc driver from sun?
You can always play with one test cmp bean called by a junit test
xdoclet can speed your test up.
Something like this in your entity:
* CMP accessor
* view-type = "local"
* column-name = "TEST"
* jdbc-type = "INTEGER"
* sql-type = "INTEGER" <-- change here till it works
public abstract int getTest();
When you have mapped Access, post the mapping here :-)
Have you considered using MSDE rather than Access? MSDE is the Microsoft Database Engine and is FREE (I think they changed their licence agreement quite recently).
MSDE works well with JBOSS as it is effectively MS SQL Server and you can manipulate it using Access...
in fact I think MSDE is distributed with Access.