Hi all !

I don't understand this error : "Could not update, currently
locked by <frontend_user> on Machine <theMachine>".

I have a FrontEnd, in which a macro runs query to update linked
tables (in the backend), wit hthe data contained in local tables.
So the macro is something like :
RunSQL : INSERT INTO <linked_table> SELECT * FROM <local_table>
Using transaction : No

There's a lot of data, so the query runs for a long time.

Now, I have a VBScript which runs from time to time, and which
inserts data in the BackEnd using an ADO connection. It looks like
this :
oConn.Provider = "Microsoft.Jet.OLEDB.4.0"
oConn.Open "Data Source=NetworkDrive:\MyBackend.mdb;User
ID=xxx;Password=xxx;Persist Security Info=True;Jet OLEDB:System
database=NetworkDrive:\MySecurity.mdw"
oConn.Execute "INSERT INTO <some_OTHER_linked_table> VALUES
(...)",, adCmdText + adExecuteNoRecords

Whenever I run this script while the macro is running, I get the
above mentionned error !

Notice that this script NEVER updates the same tables as the
macro, and the macro NEVER updates the same tables as the script !

My FrontEnd is configured for shared access, and record-level
locking. Anyway, even if page-level locking occurs, the script
NEVER runs (it should run after some time, when the data is
written by the Macro on anoter disk-page).

What am I doing wrong ?

Thanks a lot !

Arnaud