[AccessD] Same tables, Different data source (ODBC)

Hi Mark,

Am I understanding correctly that during development you either will not, or
chose not to be connected to the live Oracle tables, but in your test or
development environment you have re-created those tables in another format
so that you can work with them?

If that is the case then I have a database that connects to Oracle, do not
have that connection during development or testing and what I've done is
fairly simple (read lame).  I have the Oracle connected table and the Access
linked table, both with the same name, except whichever table is NOT live at
the time I put one or two underscores after the name.  When I post an update
to the live environment I put the underscore(s) on the Access linked table
names and remove them from the Oracle connected tables.

I am anxious to hear what others have to say because I have been meaning to
streamline this process into code for a while now.

Jennifer

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Porter
Sent: Monday, July 07, 2008 2:50 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Same tables, Different data source (ODBC)

I have an app that links to tables in an Oracle DB.  I'd like to be able to
quickly change that environment from the Dev to the Test or Prod (the tables
linked will stay the same).

 

Does anyone have any code or techniques to do this quickly?

 

Thanks in advance,

 

Mark Porter

Sr. Technologist

Nana Development Corp.

Desk: 907-265-4156

Fax: 907-343-5656

 

 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com