Error when accessing MSAccess97 from Java

[daking]

I have a Java program that needs to read data from a MSAccess 97 database. I have been added to the Workgroup and have the .mdw file. However, when trying to connect to the database I get the following error:

"Attempt 1, Connect to JDataServer on server 192.168.0.7 port:1150 Result was: java.sql.SQLException: ServerException:[ODBC Error], SQLConnect DRIVER={Microsoft Access Driver (*.mdb)};DBQ=D:\ProcConversion\PROCDATA.mdb;SystemDB=D:\ProcConversion\ProcConversion;UID=sys;pwd=sysadm DBVendorCode:-1901:, DBState:S1000:. [Microsoft][ODBC Microsoft Access Driver] Cannot start your application. The workgroup information file is missing or opened exclusively by another user."

The file isnt opened by another user and is in the same directory as the database that I am trying to connect to.

 

[lowbk]

in general, you need to check the following
1) dns is set correctly
2) the driver is correct