I have a table called "Future Events" that is located in a read-only DIR. Problem is that when the database is opened by someone the "ldb" is not not allowed to be updated since most people have only read-only access.
The solution i came up with was to create an second DB (lets call it FE-II) on a globally shared folder to "push" the data too each day. In the "Future Events" DB i created an SQL Table Delete Function that removes the old data from FE-II wia a linked table to FE-II. This works great.
Problem is when i try to push new data there and someone is currently looking at the old data (which by the way has been deleted via the SQL function), it doesnt allow me because "table is currently locked my another user".
Ive tried an update querry but it either doesnt work, or it takes far to long.
I hope i have given enough information.
If my words are confusing, i can send a diagram of this flow which may clear up any confusion in my explaination.
Thanks in advance for any assistance. Please be detailed in explainations.
mrgulic@yahoo.com
The solution i came up with was to create an second DB (lets call it FE-II) on a globally shared folder to "push" the data too each day. In the "Future Events" DB i created an SQL Table Delete Function that removes the old data from FE-II wia a linked table to FE-II. This works great.
Problem is when i try to push new data there and someone is currently looking at the old data (which by the way has been deleted via the SQL function), it doesnt allow me because "table is currently locked my another user".
Ive tried an update querry but it either doesnt work, or it takes far to long.
I hope i have given enough information.
If my words are confusing, i can send a diagram of this flow which may clear up any confusion in my explaination.
Thanks in advance for any assistance. Please be detailed in explainations.
mrgulic@yahoo.com