Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old May 27th, 2008, 12:07 AM
Authorized User
Join Date: Mar 2007
Posts: 53
Thanks: 0
Thanked 0 Times in 0 Posts
Default Multiple SQL Databases for Same Access Front End


I am a bit of a newbie at this stuff, so be gentle.

Here is the situation

I have two locations, with a SQL server in each location.
I have a SQL database at location A which is replicated to location B (All working OK)
I have one front end access 2007 front end database that i would like to use for both sites.

I have set the database to link to tables stored in location A SQL, using a ODBC connection i created. (this works fine)
I have modified the front end to point to location B SQL and created an ODBC for that one, and again tests ok.

However i would like to put in a start up form that asks the end user what location A or B and depending on the response given, use VBA to set the data source to the correct location.
Currently the tables are linked (access linked tables) whilst this was fine when i had only one location it is painful now with two, as i am still developing some forms, which means i have to maintain two front end applications, which is prone to error sooner or later.

Any Suggestions


Similar Threads
Thread Thread Starter Forum Replies Last Post
Ms Access front End with Oracle 10g Back End rahul123 Oracle 1 July 9th, 2007 01:03 AM
Multiple Front End Requery? medic7103 Access VBA 3 March 26th, 2007 07:27 AM
Oracle back-end MS-Access 2003 client front-end Corey Access 2 February 16th, 2007 08:31 AM
Oracle Back End - MS Access Front End - Multi User ckaliveas Oracle 1 February 1st, 2007 06:00 AM
poor perfomance using Access front end to SQL tanjuakio Access 24 April 19th, 2005 07:21 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.