To configure a ColdFusion MX datasource for a Microsoft Access database on a remote Windows share, the ColdFusion MX ODBC Server and ColdFusion MX ODBC Agent services in the Windows Services control panel must be run as a valid domain account instead of the local System account. The ColdFusion MX Application Server service can remain running as the local System account and does not need to run as the domain account.

Just change the two CF ODBC Services to Log On As the domain account, make sure the remote share and mdb file allow read/write for that domain account on the shared folder, restart the 2 ODBC Services, and create a datasource in the ColdFusion MX Administrator using the driver labeled as "Microsoft Access". Make sure that the datasource uses a UNC path to the mdb file in the Database File form field, and don't use a mapped drive because the mapped drive might not be available once you log off the Windows account.


If the permissions are not valid for the 2 CFMX ODBC Services, the following type of error will occur when creating a CF datasource:


Connection verification failed for data source: dbshare
[]java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.


This is different from ColdFusion 5 and earlier because in those versions the ColdFusion service itself needed to be run as the domain account.