Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Mon Jul 7 20:47:05 CDT 2008
So how about something like Tribble's relinker which allows you to point to different back ends? Not his relinker, but something along the same lines -maybe a button on the main menu or hotkey that will trigger the open file dialog box and allow you to point to a different db? Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com www.bchacc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Porter Sent: Monday, July 07, 2008 5:07 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Same tables, Different data source (ODBC) Just the data. Dev and Test will have test data, and Production will have live data. All environments will have the same data structure. Mark Porter Sr. Technologist Nana Development Corp. Desk: 907-265-4156 Fax: 907-343-5656 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Monday, July 07, 2008 3:31 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Same tables, Different data source (ODBC) What differences will there be among the three versions? Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com www.bchacc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Porter Sent: Monday, July 07, 2008 3: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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com