422,026 Members | 1,205 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 422,026 IT Pros & Developers. It's quick & easy.

error message: you can't modify the structure of table because it is already in use b

P: 2
I am getting this error when trying to modify the data type of one field in my table.

'You can't modify the structure of table because it is already in use by another person or process'

I am the only one using the table
2 Weeks Ago #1
Share this Question
Share on Google+
3 Replies


P: 2
btw, i am trying to modify that field with a lookup wizard data type, where i will get the values from another table. thanks.
2 Weeks Ago #2

PhilOfWalton
Expert 100+
P: 1,042
Nina

Can you be more specific about the table you are trying to modify and the field name and exactly your lookup function.

Phil
2 Weeks Ago #3

NeoPa
Expert Mod 15k+
P: 30,549
Hi Nina.

If you're getting that message when there are no other possible users then it may be that other windows in the same Access session, or even other Access sessions on your own computer, are the reason it can't proceed.

Try opening the database with the raw table in exclusive mode and see what you get.
2 Weeks Ago #4

Post your reply

Sign in to post your reply or Sign up for a free account.