MySQL Forums
Forum List  »  Microsoft Access

ODBC connection inside network and outside
Posted by: Bill Shaw
Date: April 04, 2011 07:06PM

Hi, We've used MS Access databases on our network for many years. We now want to update the data remotely (from home) and the best option seems to continue with Access as a front end & MySQL to hold the data. I've set up MySQL on our SBS2003, migrated the data and I can use our Access database as a front end with ODBC from home (I have a fixed IP at our work). The problem is that if I want to use the same database front end at work (within the network), I need to change from the public to private IP on the ODBC connection, or I will need 2 different front ends with different ODBC connections. Does anyone know set up the connection to MySQL so that I can use the same ODBC link?

Options: ReplyQuote

Written By
ODBC connection inside network and outside
April 04, 2011 07:06PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.