Create Alias Names for Tables 1

[jdegeorge]

Hi

I'm building a database for a client who, now after several months of development, is making a requirements change. (Bet that never happened to any of you!) Basically, I need to insert a new table of data that will refer to another one.

Problem is that it's requiring me to change the name of the first table, but because so much work has been done referring to the original name of that table, I want to be able to create an alias name for that table so I can still refer to it as it's named but also have new coding refer to its alias name.

Is there such a thing in Access or do I have to keep coding with the original name and add 'REM lines all over the place in the code?

Any help would be appreciated.

Jim DeGeorge

 

[PHV]

Access doesn't have synonym nor view, but saved queries.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[cghoga]

Jim,

Could you keep the old table as a 'holding' table maintaining the same table structure and tablename. (Or build it on the fly when the app opens or when you need to run your code.) Within the process, you would first run a delete to purge the holding table, then append the current recordset from the main table to the holding? Then you could keep your code intact.

Hope this helps.

 

[jdegeorge]

PHV

Yes...a query of the original table with the new name that I want to use. So simple yet it escaped me!

Thanks, and enjoy the star!

Jim DeGeorge