Chuck - I am looking for a way for both MS access and MySQL to share realtime data so that if someone where to insert (through a web based admin) or update table in a MySQL db you could open your Access db and see the same data. I don't know if it is possible but that way there wouldn't be an export to MySQL procedure. Does that make sense?
I don't know much about Myodbc except it allows you to export your Access database to MySQL. My question is if MySQL gets updated does Access get updated too? I have a client who wants everyone in the office to have the ability to update and view data in an Access db. My understanding of how access works is only one person can be connected or update the db at a time.(depending on the # of odbc connection you have) My thought was if we got Access and MySQL talking, I could create a web based admin that would allow many folks to query and update the MySQL db and if MySQL and Access are talking then the data in the Access db would get updated as well. Really just trying to create a remote way to access and update from the Access db. Sorry for the long story but is this something you've done or is it not at all possible? Any ideas? Thanks Mark At Friday, 22 March 2002, "Chuck Roberts" <[EMAIL PROTECTED]> wrote: >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 <mysql-unsubscribe-mstringham=edeasolutions. com@lists. >mysql.com> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > Regards, Mark Stringham 801.602.8791 --------------------------------------------------------------------- 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
