Multi users on Access Databases

[ysommer]

I built a asp.net application that uses an Access DB.
The application is suppose to work with a couple of users that insert and delete info from the DB. When the connection is open by a user to the DB and another is trying to connect to the DB, the computer throws a exception. How do I avoid that?

 

[davisg]

Hi ysommer,

Have you made sure that you are not openning the Access Database in exclusive mode and have you set record level locking? You do this from the Tools/Options menu within Access.

Geoff.

 

[chiph]

Access has known limitations with multi-user access. If you're running on a perfect network (zero dropped frames) and your program never crashes, you can do it. But otherwise you'll be rebuilding corrupt databases all the time.

You'd be better off with MSDE (which is a free download to all Visual Studio owners if it didn't already come in your box). It's the desktop edition of MS SQL Server, and it can handle 10 active connections at a time, which if you structure your application correctly (don't hold onto database connections) you can get 40 or 50 users on it.

Chip H.