I'm doing something similar, with an Access front-end and mysql back-end. > -----Original Message----- > From: Mark Stringham [mailto:[EMAIL PROTECTED]] > Sent: Friday, March 22, 2002 3:11 AM > To: MySQL > Subject: MySQL, MyODBC and MS Access > > > > I have a project where I may need to connect an MS > ACCESS db and MySQL. I > have read some pretty good documentation and know that > is possible to take > an existing Access db and export it to MYSQL. I have a > few questions and > wondered if someone might offer some insight. > > 1. Where must the Access db reside in order to talk with MySQL?
It doesn't matter. As long as you install Myodbc on the client with Access, then myodbc can talk to mysql. > 2. After the import to MySQL, if I insert new data > into MySQL will the > Access db be updated as well? Not automatically. If you want the databases each to be updated automatically, I don't think you can replicate between Access and Mysql. Either both dbs have to be Access or both Mysql. > > I am looking for a way to access live MS Access data > from the web. > Obviously, I could connect directly to the Access db > itself but with limited > connections, I would think it would be hard to share > the data . My thought > was when someone updated the Access db, the data is > then exported to MySQL. > I then could use php, JSP or whatever to access the > data from the web > without having to worry about odbc connections. We're doing the exact same thing. We have Access as a front-end, and myodbc installed with the client (on the front end). In Myodbc, you specify a data source with an IP address and database name. That connects to a Mysql server running on the same IP address. The only problem we're having is how to encrypt the data between the client (Access) and server (mysql). Mysql supports SSL but Access does not. We're looking at using stunnel (which uses openssl, www.openssl.org), which is like a gateway between Access and Mysql. Chuck --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
