Connect to remote Access DB

[Jatrix]

I am attempting to connect to an Access DB that is password protected on another server. Whenever I enter the path I get this error:

Connection verification failed for data source: CreditTraining_CassRegistration
[]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.


I am a newb at this sort of thing, and I may be entering the path wrong

\\Nas01\sterling\Data\Credit........

Does anyone know if this is possible and if so, any tips?

[paross1]

This is an old tech note, but it may be related to your problem and it might help point you in the right direction.

ColdFusion MX 6.1: Connection error when configuring a remote Microsoft Access database

Phil