J
Joe Rich
I am importing data into a temp table from which I move it
into ListView. Before the import, I check to see if the
table exists. If so I delete it. Then use the
TransferSpreadsheet command to recreate it.
This works the first time. However, the second time i try
to import the spreadsheet, when I attempt to delete the
temp table, I get a Error 3211 (table in use). It appears
at though anytime I use TransferSpreadsheet to import data
into a table, that table is locked and cannot be unlocked
except by exiting ACCESS. No other user has acccess to
this temp table. Can this be the case? Is there a way to
tell ACCESS to unlock that table?
PS. I have tried to use the acLINK option rather than the
acIMPORT, but then I get a message saying the linked file
is locked and the link cannot be deleted.
into ListView. Before the import, I check to see if the
table exists. If so I delete it. Then use the
TransferSpreadsheet command to recreate it.
This works the first time. However, the second time i try
to import the spreadsheet, when I attempt to delete the
temp table, I get a Error 3211 (table in use). It appears
at though anytime I use TransferSpreadsheet to import data
into a table, that table is locked and cannot be unlocked
except by exiting ACCESS. No other user has acccess to
this temp table. Can this be the case? Is there a way to
tell ACCESS to unlock that table?
PS. I have tried to use the acLINK option rather than the
acIMPORT, but then I get a message saying the linked file
is locked and the link cannot be deleted.