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?
The Value of Experts Exchange in My Daily IT Life
Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>
Mike
Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 1 Answer and 11 Comments.
View membership options“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck
Member since 2004
Our community of experts have been thoroughly vetted for their expertise and industry experience.