Database locked

[Guest]

I was attempting to paste about 20,000 records from a spread sheet into a
table. I cannot remember exactly what the error said but it was something to
do with increasing the levels of record locks I think.
The database is now locked and I can only open it by opening Access then
clicking on File open etc.
I have tried compact and repair but this hasn't helped.
Sorry to be so vague, does anyone have any suggestions?
I am using Access 2003.
Thanks.

 

[John Vinson]

I was attempting to paste about 20,000 records from a spread sheet into a
table. I cannot remember exactly what the error said but it was something to
do with increasing the levels of record locks I think.
The database is now locked and I can only open it by opening Access then
clicking on File open etc.
I have tried compact and repair but this hasn't helped.
Sorry to be so vague, does anyone have any suggestions?
I am using Access 2003.
Thanks.

If there is a file in the same directory as the database with the same
name, but a .ldb extension, delete it. Open the database and Compact.

Rather than copying and pasting - which works ok for spreadsheets but
is not ideal for tables - open Access, and use File... Get External
Data... Import. Select Excel as the source type, and select your
spreadsheet. This will let you import to an existing table as well as
into a new table, and shouldn't have the locks problem.

John W. Vinson[MVP]

 

[Guest]

Thank you very much John.

If there is a file in the same directory as the database with the same
name, but a .ldb extension, delete it. Open the database and Compact.

Rather than copying and pasting - which works ok for spreadsheets but
is not ideal for tables - open Access, and use File... Get External
Data... Import. Select Excel as the source type, and select your
spreadsheet. This will let you import to an existing table as well as
into a new table, and shouldn't have the locks problem.

John W. Vinson[MVP]