By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,705 Members | 1,891 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,705 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

Expert 100+
P: 1,430

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

Feb 8 '18 #3

Expert Mod 15k+
P: 31,411
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.