2. ASPRunnerPro General questions
  3. Connecting to a database that is in use.
This topic is locked

Connecting to a database that is in use.

 		10/4/2004 11:43:02 AM
ASPRunnerPro General questions
author

How can I sucsesfully connect to a database that has another program connected to it? I know my connection string is correct as some times it makes the connection

and displayes the rows correctly.
I mean I get the following errors when I cannect to my database.

When I do a refresh I recive diffrent error messages.
--------------------------------------------------------------------------------------------

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xdf0 Thread 0x1100 DBC 0x2331f04 Jet'.

--------------------------------------------------------------------------------------------

[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

--------------------------------------------------------------------------------------------

[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.

--------------------------------------------------------------------------------------------
Do the errors above mean I can only connect to the database when nothing else is using it? If so then this is going to be very difficult to use in a working enviroment.
Any help or advice you can give will be appreciated.
Thank you

Bob
Sergey Kornilov admin 10/6/2004

Bob,
first of all you need to make sure that this application works fine when you are the single user who accesses this database file. Sometimes this error message means problems with connection string.
In theory several people can work with MS Access database simultaneously. Just make sure nobody opens database tables in Design mode which locks this table.
501089 10/6/2004

Hi Sergey,
Thank you for coming back to me on this issue.
When I know no one is connected to the database the asp code works correctly.

This would kill of the theory of a connection string issue.
But when the database is in use the asp code comes back with the errors stated in the first e-mail.
Regards

Bob
Sergey Kornilov admin 10/7/2004

Bob,
MS Access designed to work in multiuser enviroment. What exactly other people do with this database when you get this error?