423,131 Members | 2,110 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,131 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
Feb 7 '18 #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.
Feb 7 '18 #2

PhilOfWalton
Expert 100+
P: 1,262
Nina

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

Phil
Feb 8 '18 #3

NeoPa
Expert Mod 15k+
P: 30,910
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.
Feb 9 '18 #4

Post your reply

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