Why has my table locked?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rhianne - 27 Sep 2007 14:25 GMT

I have reason to add a new column into my table and before today have had no
problem with doing so and then using that as the control source for new text
box on form view.

When I tried to do this earlier I was informed by access that the table
could not be locked as it was being used by another user or process.

am totally confused!

Reply to this Message

Douglas J. Steele - 27 Sep 2007 15:02 GMT

Did you have any forms or queries open the first time? If you were doing
anything that used the table you were changing, you'd have got that message.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I have reason to add a new column into my table and before today have had
>no
[quoted text clipped - 6 lines]
>
> am totally confused!

Reply to this Message

Rhianne - 27 Sep 2007 15:24 GMT

I did delete some unwanted rows from the table, will this have somethinfg to
do with it?

> Did you have any forms or queries open the first time? If you were doing
> anything that used the table you were changing, you'd have got that message.
[quoted text clipped - 9 lines]
> >
> > am totally confused!

Reply to this Message

Douglas J. Steele - 27 Sep 2007 15:30 GMT

It should only have mattered if the query you used to delete the rows was
still open while you were trying to change the table.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I did delete some unwanted rows from the table, will this have somethinfg
>to
[quoted text clipped - 15 lines]
>> >
>> > am totally confused!

Reply to this Message

Rhianne - 27 Sep 2007 15:50 GMT

there were not queries - I deleted empty rows, as I assumed they were blank
forms, that had been created when trialling the database.

> It should only have mattered if the query you used to delete the rows was
> still open while you were trying to change the table.
[quoted text clipped - 18 lines]
> >> >
> >> > am totally confused!

Reply to this Message