VB Run-time error '3211'

  • Thread starter Thread starter Tony Girgenti
  • Start date Start date
T

Tony Girgenti

I'm trying to execute the following code and i am getting this error:

"Run-time error '3211'; The database engine could not lock table 'Items'
becuase it is already in use by another person or process".

This code is being executed in AccessXP using an ODBC connection to a server
DB. I'm not sure exactly which statement it is giving the error on.
All other computers were turned off and the one computer was restarted, but
we still get the error.

Any help would be greatly appreciated.

Tony

============================================================================
=================================
CurrentDb.Execute "DROP TABLE Items"

DoCmd.TransferDatabase acImport, "ODBC Database", _

"ODBC;DSN=DEMO2ENG;ArrayFetchOn=1;ArrayBufferSize=8;DBQ=DEMO2ENG;OpenMode=0;
DecimalSymbol=.;;TABLE=Items", _
acTable, "Items", "Items"
CurrentDb.Execute "CREATE UNIQUE INDEX ItemNumIdx ON Items (ItemNumber)"
 
I'm trying to execute the following code and i am getting this error:

"Run-time error '3211'; The database engine could not lock table 'Items'
becuase it is already in use by another person or process".
Click to expand...

Is the Items table open on a Form? If so, that form is the other
"user".
 
Back
Top