ODBC sharing with Access interface and ASP

[franklin1232]

I have one user who updates a database on the network. This user uses an Access interface. When she is in the database the ASP connection fails. What can I do to share the database with my ASP connections. I am assuming that it is a setting in Access because I have my ASP ODBC connection set to share | Read. I should probally post in the Access forum as well.

 

[Tarwn]

When your user is in access it locks itself to other users making changes in it. This is a standard read/write lock that acces makes to keep other users from editing the data while a single user is already in there. The reasoning behind this is to keep the data integrity.
I am not sure you can change the way it locks the db when someone actually has it open, on my machines it only appears to happen when I actually have a table open and in the middle of editing a record or field, the rest of the time the connection goes through. If you post on the access forum be sure to post the version number as well (95, 97, 2000, xp).
-Tarwn ------------ My Little Dictionary ---------
Reverse Engineering - The expensive solution to not paying for proper documentation

 

[roy29]

A possible solution would be to have 2 databases. One for the network users and one for the web users. Since the web users only lock the database for short amounts of time there would be little or no contention for the database. You would have to link the 2 databases together but since you're using access you're kind of limited.