Access 2002 columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brittany - 28 Mar 2007 23:32 GMT

Hello all. I'm trying to add a column to my database in Access 2002 and it
won't let me. The error message that keeps popping up is " Could not lock
table 'Calling List'; currently in use by user 'Admin' on machine
"Frontdesk". I don't understand what I'm doing wrong, I've been using this
database for months and never had this happen. Can anyone help me add a
column?

Reply to this Message

KARL DEWEY - 29 Mar 2007 00:04 GMT

Back up your database, close it.
Open Windows Explorer and locate the .mdb file. If you also see a file with
the same name but with .ldb as extention then try to deleted it.

Signature

KARL DEWEY
Build a little - Test a little

> Hello all. I'm trying to add a column to my database in Access 2002 and it
> won't let me. The error message that keeps popping up is " Could not lock
> table 'Calling List'; currently in use by user 'Admin' on machine
> "Frontdesk". I don't understand what I'm doing wrong, I've been using this
> database for months and never had this happen. Can anyone help me add a
> column?

Reply to this Message

Brittany - 29 Mar 2007 00:12 GMT

That was a little too advanced for me. I don't know how to backup the
database. Can you tell me why it's doing this now? Am I supposed to delete
the .mdb file too?

> Back up your database, close it.
> Open Windows Explorer and locate the .mdb file. If you also see a file with
[quoted text clipped - 6 lines]
> > database for months and never had this happen. Can anyone help me add a
> > column?

Reply to this Message

KARL DEWEY - 29 Mar 2007 00:42 GMT

>> Am I supposed to delete the .mdb file too?

NO!

The .ldb file is known as the 'locking file' and is used so that two people
can not try to change the same data at the same time. It also won't let you
make some database changes unless you are the only one in the database.

Sometimes it get corupted and does not self erase when everyone gets out of
the database.

>>I don't know how to backup the database.

An easy way is to just copy and paste the .mdb file in another folder for
save keeping. If you mess up you always have the copy that was made BEFORE
you did stuff to the database.

>>That was a little too advanced for me.

What can you not do? Can you not use Windows Explorer?

If you can not delete the .ldb and are working on a LAN then have your IT
guy do it.

Signature

KARL DEWEY
Build a little - Test a little

> That was a little too advanced for me. I don't know how to backup the
> database. Can you tell me why it's doing this now? Am I supposed to delete
[quoted text clipped - 10 lines]
> > > database for months and never had this happen. Can anyone help me add a
> > > column?

Reply to this Message

Brittany - 29 Mar 2007 03:02 GMT

Ok that makes way more sense now. Thank you very much for your help!

> >> Am I supposed to delete the .mdb file too?
> NO!
[quoted text clipped - 31 lines]
> > > > database for months and never had this happen. Can anyone help me add a
> > > > column?

Reply to this Message