Why has my table locked?

R

Rhianne

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!
 
D

Douglas J. Steele

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.
 
R

Rhianne

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

Douglas J. Steele

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.
 
R

Rhianne

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