Name Autocorrect (1 Viewer)

[neileg]

I'm tasked with updating a db that was created in A97 and converted to A2k. I am using A2k SP3.

Some of the tables have a colon in the name, e.g. Tbl:Budget. I thought I would delete the colon and use Name Autocorrect to propogate the changes, but I can't get it to work. I have turned on the three options in Options. When I rename a table and try to open a query based on that table, I get an error message telling me that the table can't be found. Am I missing something?

 

[mdcory]

There is a utility here, find and replace, that will do what you are looking for. I have used it and it works great.

 

[neileg]

Yes! Worked like a dream. Many Thanks.

 

[Pat Hartman]

There is a known bug with db's converted from A97 where the AutoCorrect doesn't work. You could create a new db and then import all the objects. That might work.

 

[neileg]

Thanks for the tip, Pat. I had read that SP3 sorted out this bug, but clearly it didn't work in my case. If I need to do this again, I'll try your suggestion, just to see if it works!