1. Copy the MS access jdbc-odbc driver jar file to the server/default/lib directory.
http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/bridge.doc.html

Copy msaccess-ds.xml from /docs/examples/jca directory to
/server/default/deploy directory.

In the msaccess-ds.xml set the connection-url to jdbc:odbc:<DSNNAME>. <DSNNAME> variable is the DSN name. Set the user-name and password.

In the standardjbosscmp-jdbc.xml set

<jbosscmp-jdbc>

   <defaults>

      <datasource>java:/MSAccessDS</datasource>

      <datasource-mapping>MS ACCESS</datasource-mapping>

   </defaults>

</jbosscmp-jdbc> 

In the standardjbosscmp-jdbc.xml add a type-mapping for MS ACCESS.

In the login-config.xml add a login configuration for MS ACCESS

<application-policy name = "MSACESSDbRealm">

   <authentication> 

      <login-module code =  

  "org.jboss.resource.security.ConfiguredIdentityLoginModule" 

                            flag = "required">

         <module-option name = "principal"></module-option>

         <module-option name = "userName"></module-option> 

         <module-option name = "password"></module-option> 

         <module-option name ="managedConnectionFactoryName">  

                   jboss.jca:service=LocalTxCM,name=MSAccessDS 

         </module-option> 

      </login-module> 

   </authentication>

</application-policy>