Updating more than two queries/tables error (1 Viewer)

biofaku

Member
Local time
Today, 07:34
Joined
May 15, 2020
Messages
66
Hi, I have stump with an error when I try to update/refresh the queries or tables on my workbook, it's the error "The database has been placed in a state by user...(etc.)" any idea on how fix it? I have been told it might be related to the build version but maybe any of you have found a workaround. Its really annoying because the workbook uses a lot of tables and queries to work.
 

Isaac

Lifelong Learner
Local time
Today, 03:34
Joined
Mar 14, 2017
Messages
8,738
Check out the instructions on this page regarding making sure the source db is not being opened in exclusive mode.
 

biofaku

Member
Local time
Today, 07:34
Joined
May 15, 2020
Messages
66
Going to check it out, if I fix it I will come back, thanks in advance :)
 

biofaku

Member
Local time
Today, 07:34
Joined
May 15, 2020
Messages
66
Ok, My db is on shared state and on a safe location, so I can discard those. I don't know about that binarybuffer that I have read down on the thread if it can fix my problem, seems complicated.


EDIT:

Just made a rollback on the DB and it's working perfectly, I think the error might be related to using a linked excel table on the access file.
 
Last edited:

Users who are viewing this thread

Top Bottom