Skip to main content
Inspiring
June 17, 2008
Question

Connect to remote Access DB

  • June 17, 2008
  • 1 reply
  • 661 views
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?
This topic has been closed for replies.

1 reply

Participating Frequently
June 17, 2008
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