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?
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.
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.