I am having a multi-user database problem with an access my VB6/Access 97.
Via ODBC, I am using a System DSN with a Microsoft Access Driver called "judge".
In my ADODC control on the form, I have the Connection String pointing to the ODBC judge. I have the CursorType set to Openkeyset, and the LockType to Pessimistic.
In the form code I do the following:
Set cn = New ADODB.Connection
cn.Open judgedatabase
When I execute the app form on one PC only everything works fine. However, if I open the app form on a second PC then I get the error "[Microsoft][ODBC Microsoft Access Driver] Cannot open database '(unknown)'. It may not be a database that your application recognizes, or the file may be corrupt.
I have tried some other things without any success and I feel like I am missing something simple. Any help would be appreciated.
Thanks.
Via ODBC, I am using a System DSN with a Microsoft Access Driver called "judge".
In my ADODC control on the form, I have the Connection String pointing to the ODBC judge. I have the CursorType set to Openkeyset, and the LockType to Pessimistic.
In the form code I do the following:
Set cn = New ADODB.Connection
cn.Open judgedatabase
When I execute the app form on one PC only everything works fine. However, if I open the app form on a second PC then I get the error "[Microsoft][ODBC Microsoft Access Driver] Cannot open database '(unknown)'. It may not be a database that your application recognizes, or the file may be corrupt.
I have tried some other things without any success and I feel like I am missing something simple. Any help would be appreciated.
Thanks.
