troubleshooting Question

Access 2000 - error 3046

Avatar of donpick
donpick asked on
Microsoft Access
11 Comments1 Solution735 ViewsLast Modified:
Access 2000 (Office patched to service pack 3), running on Windows 2000 Pro workstations, main Access file running on Windows 2003 server.

My client has a central Access database .  Each user has an Access database on their own pc which has linked tables to the central one.  He recently installed a new server.  No changes were made the the Access database.  Now, when one user (Julie) runs a report and other users try to use the database, the Access program aborts with the error:
      3046:  Could not save; currently locked by another user.

Julie is able to run her reports but no one else can view any data or updated any data.  All databases have been compacted / repaired several times.  

I cannot find any info on error 3046 except the text "Could not save; currently locked by another user."  

Any ideas?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 11 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros