Importing spreadsheet into a temp table locks the table

Discussion in 'Microsoft Access External Data' started by Joe Rich, Jul 7, 2003.

  1. Joe Rich

    Joe Rich Guest

    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.
     
    Joe Rich, Jul 7, 2003
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. barry sharp

    Importing XLS spreadsheet into access database

    barry sharp, Feb 17, 2004, in forum: Microsoft Access External Data
    Replies:
    1
    Views:
    196
    Joan Wild
    Feb 17, 2004
  2. Alex Saager

    Importing an excel spreadsheet into Access

    Alex Saager, May 28, 2004, in forum: Microsoft Access External Data
    Replies:
    1
    Views:
    167
    Ken Snell
    May 28, 2004
  3. jwr

    Importing Spreadsheet/Linking spreadsheet

    jwr, May 25, 2006, in forum: Microsoft Access External Data
    Replies:
    7
    Views:
    250
    Douglas J. Steele
    May 27, 2006
  4. importing to temp table first

    , Jul 23, 2007, in forum: Microsoft Access External Data
    Replies:
    2
    Views:
    155
    Guest
    Jul 23, 2007
  5. Shawky

    Extracting data from one table into a temp table

    Shawky, May 1, 2008, in forum: Microsoft Access External Data
    Replies:
    3
    Views:
    340
    quintero
    May 26, 2008
Loading...

Share This Page