Renaming Table Changes Query or Script

dantebothermy

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

ADezii

Quote:

Originally Posted by dantebothermy

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

Try:

Tools ==> Options ==> General Tab ==> Name AutoCorrect
1. Select ==> Track name AutoCorrect info
2. Select ==> Perform name AutoCorrect

dantebothermy

Thank you ADezii,

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

Dante

Renaming Table Changes Query or Script

re: Renaming Table Changes Query or Script

re: Renaming Table Changes Query or Script

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about