By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,299 Members | 1,228 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,299 IT Pros & Developers. It's quick & easy.

Convert to Local table - Access

P: 1
I right clicked on a yellow coloured table icon to look at its properties, unfortunately I accidentally clicked on 'Convert to local table'. It's turned to a blue/white icon and I'm unable to reverse the conversion at all. I don't know what 'local table' means and I'm desperate to undo this! Help!
Apr 17 '15 #1

✓ answered by Seth Schrock

Delete the table and then relink to the table in your backend.

Share this Question
Share on Google+
2 Replies


Seth Schrock
Expert 2.5K+
P: 2,951
Delete the table and then relink to the table in your backend.
Apr 17 '15 #2

zmbd
Expert Mod 5K+
P: 5,397
Only caution here,
Rename your local table first
Then relink to your backend
Make sure your data is good
Then delete the renamed table.
Apr 17 '15 #3

Post your reply

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