K
kohai
Hi,
I have 2 access databases where one holds all of my underlying data (several
million rows) and the second holds all of the calculated info I need from the
first. Since I mostly use the calculated from the 2nd, I need to store this
info b/c it takes too long to always run the data from the first. Some of
the tables in the 2nd link back to the 1st.
My question is, when working in db #2 if I try and use a linked table in a
query from db#1 I get the following message:
The database has been placed in a state by user 'Admin' on machine xyz that
prevents it from being opened or locked.
What setting(s) do I need to change so that I get rid of this problem? Both
db's are set to open in a shared mode, not exclusive (as shown under
tools/options/advanced tab) and I am the only one using them.
Thanks.
kohai
I have 2 access databases where one holds all of my underlying data (several
million rows) and the second holds all of the calculated info I need from the
first. Since I mostly use the calculated from the 2nd, I need to store this
info b/c it takes too long to always run the data from the first. Some of
the tables in the 2nd link back to the 1st.
My question is, when working in db #2 if I try and use a linked table in a
query from db#1 I get the following message:
The database has been placed in a state by user 'Admin' on machine xyz that
prevents it from being opened or locked.
What setting(s) do I need to change so that I get rid of this problem? Both
db's are set to open in a shared mode, not exclusive (as shown under
tools/options/advanced tab) and I am the only one using them.
Thanks.
kohai