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

Renaming Table Changes Query or Script

P: 47
Hi,

I'm using Access 2003.

Sometimes, when I have a table used in a query, if I rename the table it Access also renames the table in the query. It's also happened in VB scripts.

It doesn't do it consistently, but it scares me.

Does anyone have any advice how I might be able to avoid this?


Dante
Jun 30 '09 #1
Share this Question
Share on Google+
2 Replies


ADezii
Expert 5K+
P: 8,679
@dantebothermy
Try:
  1. Tools ==> Options ==> General Tab ==> Name AutoCorrect
    1. Select ==> Track name AutoCorrect info
    2. Select ==> Perform name AutoCorrect
Jun 30 '09 #2

P: 47
Thank you ADezii,

this has been puzzling me (and the tech support folks here) for months.

Dante
Jun 30 '09 #3

Post your reply

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