J
JS
Posted in another thread, but I think it's more relevant
here...
Anyway, here's the setup of my files:
I have one master file with a large table on it. I also
have a satellite file that I have given to each user. On
this satellite, I have the large table linked so users
can do simple queries.
Now the problem: I have the master set to update itself
every morning at 5:00 AM (it's a 'screenshot' of a table
inside our enterprise system). If someone is inside
their satellite file, the master can not update itself
since the table becomes locked.
I haven't been able to figure out how to either unlock
the table, or have it so the satellites do not lock it in
the first place. Any advice is appreciated.
Thanks,
Joe
here...
Anyway, here's the setup of my files:
I have one master file with a large table on it. I also
have a satellite file that I have given to each user. On
this satellite, I have the large table linked so users
can do simple queries.
Now the problem: I have the master set to update itself
every morning at 5:00 AM (it's a 'screenshot' of a table
inside our enterprise system). If someone is inside
their satellite file, the master can not update itself
since the table becomes locked.
I haven't been able to figure out how to either unlock
the table, or have it so the satellites do not lock it in
the first place. Any advice is appreciated.
Thanks,
Joe