Networks

Ask something
Discussion Locked

MS Access and System Resources

0 helpful
2 replies

by qps

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I just put a standard MS Access complete database on our server with shortcut links on each employeee's desktop to access the same database. Some of us get in fine. However, a couple employees will open the database and get an error message that reads somewhat like this: "[06] has put the database in a state that can't be opened or locked"?? And then that employee can't get in until the other get's out.

Also, we discovered that a couple employees' System Resources decreases with the increase of usage of the program to where it eventually freezes their system.

What am I doing wrong???

FYI - I'm a ACCESS 'wannabe', no training. I just know enough to be dangerous.

Thanks

2 replies

by glen_mcleod

With regards to the "can't open" problem, that's just classic Access. It's meant to handle around 6-8 concurrent connections, more (maybe 15) if the application is written well, and less if it is written badly.

Freezing the employees' systems sounds like a badly written app. The "optimal" way to run a multi-user Access app is to have the tables in one database file on the server, with each user having their own copy of the "program" file (forms, reports, queries, code, etc.) on the local machine with the tables linked to the server file.

Sorry to say, it sounds like you need a re-write.

Glen

This discussion is closed to new replies.