MS Access and System Resources - TechRepublic
General discussion
January 6, 2003 at 03:48 AM
qps

MS Access and System Resources

by qps . Updated 23 years, 6 months ago

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

This discussion is locked

All Comments