469,358 Members | 1,659 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,358 developers. It's quick & easy.

How can I stop the accdb file from locking?

I am using a microsoft access 2007 database. We recently updated our computers to office 2010, but have not update the actual database on the server.

I have up to fifty people accessing the database at once. I am not very familiar with Access, but I am having a consistent problem. The database locks and gives the message "could not save; currently locked" or "could not update; currently locked". How can I fix this?

This is a HUGE hindrance to use. We are shifting to SQL server and are in the process of designing that now, but for a little while longer, we are tied to this database. Any responses would be of great help!

Thank you.
Feb 11 '11 #1

✓ answered by TheSmileyCoder

I am no expert on how access functions in a multiuser environment when all users use the same frontend and backend. My own databases are split in a front and a backend (and have around 30 concurrent users without trouble). Each user has their own frontend, which in my experience does not cause trouble.

4 3314
TheSmileyCoder
2,321 Expert Mod 2GB
Does your database currently use a seperate backend and frontend?
Feb 12 '11 #2
Nope. Should I split it?
Feb 12 '11 #3
TheSmileyCoder
2,321 Expert Mod 2GB
I am no expert on how access functions in a multiuser environment when all users use the same frontend and backend. My own databases are split in a front and a backend (and have around 30 concurrent users without trouble). Each user has their own frontend, which in my experience does not cause trouble.
Feb 12 '11 #4
I have split it. I also took the precaution of converting the front end to an accdbe file. We'll see what happens.

Thanks.
Feb 12 '11 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Geoffrey | last post: by
2 posts views Thread by Kamus of Kadizhar | last post: by
4 posts views Thread by Stanley Cheung | last post: by
4 posts views Thread by darrel | last post: by
2 posts views Thread by Dr. Who | last post: by
15 posts views Thread by Matt Brandt | last post: by
1 post views Thread by =?Utf-8?B?REZTIEhFTFAgV0FOVEVE?= | last post: by
2 posts views Thread by Sparky | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.