I have a Backend access database that is serviced by multiple front ends on user machines on a network.
The front end has an append query that appends a table in the 'backend' from a table in the frontend.
The problem arrises if more than one user runs the query at the same time (sods law says they will).
The query will not append records because the records are locked while the first query appends the table.
Will I need to implement some sort of transaction to assess whether the table is locked? If so how? I'm ignorent when it comes to coding in access so can I get around it with any built in function? If not can you give me a clue as to the code required and how to implement it?
Thanks - Falc