Table name changed, how do I...

  • Thread starter Thread starter Jason Gyetko
  • Start date Start date
J

Jason Gyetko

I had to change the name of a couple tables to get rid of a space in the
name Ex: Table One = Table_One.

I searched through all the code and replaced it accordingly, but all my
forms, queries, & macros still have the old name. Is there a way to search
and replace in them as well, or do I have to manually go through and do it?
Thanks.
 
What version of Access are you using? Access 2000 and above should fix this
for you automatically unless you turn the option off (Tools -> Options ->
General "Track Name Autocorrect Info" and "Perform name AutoCorrect"). If
you are using Access 97 or below you must change it by hand. You could write
code to do it but that would probably take longer then doing it by hand -
unless you can find an add in for it. I have code that will search forms and
queries but not make changes in them.

--Steve Huff
 
Thanks, they were disabled.

I enabled them, but my frontend application has all linked tables. Is that
still supposed to work if I make changes to the backend access DB? It looks
like it does not, so I exported all the tables into my frontend db instead
of using the links, then made the changes to the tables. I found that it
made the appropriate change in one form, but most of my stuff did not get
modified.

Can I get the code you have to search the forms and queries so I can see
what didn't get updated?
 
Access 2000

Steve Huff said:
What version of Access are you using? Access 2000 and above should fix this
for you automatically unless you turn the option off (Tools -> Options ->
General "Track Name Autocorrect Info" and "Perform name AutoCorrect"). If
you are using Access 97 or below you must change it by hand. You could write
code to do it but that would probably take longer then doing it by hand -
unless you can find an add in for it. I have code that will search forms and
queries but not make changes in them.

--Steve Huff
Click to expand...
 
Hi Jason,

Just a quick comment to explain your observation regarding NameAutocorrect:

"I found that it made the appropriate change in one form, but most of my stuff did not get
modified."

In order for NameAutocorrect to even attempt to function correctly, the name maps must be
up-to-date in your database before you attempt to rename a field, table or query. The name maps
were likely not up-to-date since you had already disabled this most buggy feature (a good
thing!). In order to update the name maps, you need to first turn NameAutocorrect back on. Then
open each object (tables, queries, forms, reports) in design view, and click on the save button.
Do this before you attempt to rename anything. Then, you'll have a reasonable chance of success
with NameAutocorrect.

The same procedure is required for databases that have been converted from the Access 97 format
to the Access 2000 format, since there would be no associated name map in a converted database.

Tom

____________________________________


Thanks, they were disabled.

I enabled them, but my frontend application has all linked tables. Is that
still supposed to work if I make changes to the backend access DB? It looks
like it does not, so I exported all the tables into my frontend db instead
of using the links, then made the changes to the tables. I found that it
made the appropriate change in one form, but most of my stuff did not get
modified.

Can I get the code you have to search the forms and queries so I can see
what didn't get updated?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change table info 2
DB2 linked tables have underscore in column names. 0
Name Changes 3
VBA - retrieve data on last create named range from previous inserted named range 0
How can I quickly change the table name in a query? 15
Macro Results, How to filter? 1
Counting multiple memberships 1
How change table name including references in forms and queries? 1

Back
Top