Why has my table locked?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 
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.
 
there were not queries - I deleted empty rows, as I assumed they were blank
forms, that had been created when trialling the database.
 
Back
Top