odbc

[joeythelips]

Hi,

I have an access database that links to an oracle db.

I have about 200 queries written that are based on these tables. The oracle database is called iscustdb so all the linked tables are prefixed with iscust_tablename.

In the past month, we have gone live with another database called nicustdb. I now want to replicate all the queries in the access database above in a new access d/b. Obviously all the linked tables from the new database will have an Nicust prefix

Is there something i can do to have the nicust linked tables appear as iscust so i would not have to change my queries?

Joe

 

[BillPower]

Hi joeythelips, just rename the new tables to iscust, it doesn't matter what a linked table is called once the link has been established. Obviously try this 1st in a copy of your new DB.

 

[GingerR]

I agree. You can name the tables anything you want in your database.

 

[AccessNerd]

I have a similar situation. I have many Access apps that are front-ends to Oracle databases. In all cases I have a production and test version of the databases. The table names are the same but the schemas are different. What I do is link in one version then take out the schema prefix from the Access link. For example, when I link production.activity_tbl, Access creates a link name of production_activity_tbl. I take out "production_" leaving activity_tbl. All my queries are based on the somewhat generic table names. Now I want to use the test tables in the same queries. I created a sub to relink the Access links to the test tables and another to relink to production. This way I can easily switch back and forth between the two databases without changing queries, forms or reports. If you would like to see the code, give me your email address.

 

[joeythelips]

Hi,

Thanks very much for all your replies.

They are much appreciated.

Joe