Does the same scenario apply to MySQL database on a Linux server? Yvon
Bill Easton wrote: > On the grounds that someone else may have this problem, and in response to > John's post, below, I am providing a "cookbook" of how to do what I asked. > > The problem: I have a bunch of users, all with small local MySQL databases > on their Windows boxes (which get synchronized with a large server > database--but they need to be able to work offline.) They mostly have and > know Microsoft Access, and we have a requirement to support letting them get > to their data in Access. Turns out you can bring up the MySQL database in > Access just fine. > > BTW, we did consider just using Access locally, with the JDBC-ODBC bridge. > It worked, but we weren't very impressed with how robust it was. Also, it > would have been harder to avoid having the users modify "my" database. > > The cookbook: > > (1) Install ODBC: > - Download ODBC from the mysql.com page and unzip into a directory. (Note > there are downloads for 95/98/ME and NT/2000/XP. These differ by one file: > The file odbc.inf is a copy of odbc.95 or odbc.NT, as appropriate. Also, > there are both readme and README--which confuses Windows--they are the > same.) > - Run the installer, SETUP.EXE > > (2) Link to your MySQL database from Access > - Start Access > - Use the wizard to create a new Access database > - Click File | Get External Data | Link Tables > - Select Files of Type: ODBC Database > - Select the Machine Data Sources tab > - Click New > - Select User or System Data Sources, as desired > - Click Next > - Select MySQL and click Next > - Click Finish > - You should get an ODBC driver configuration screen. Fill in: > Windows DSN name: Name you would like to use for this data source. > MySQL host (name or IP): localhost > MySQL database name: The name of the database. > - Click OK > - Your new data source should be selected; Click OK > - You will get a Driver connect screen (which looks like the configuration > screen above) - Click OK > - You will get a list of tables. Select those you want to see through > Access. > - Voila! You can now access the tables through the Access database screen. > > > From: "john" <[EMAIL PROTECTED]> > > To: "MySQL Lists" <[EMAIL PROTECTED]> > > Subject: RE: accessing MySQL database from Access > > Date: Fri, 5 Apr 2002 08:33:56 -0600 > > > > You know this sounds like a good idea, and I know this is what the > utilities > > are for that come provided with mysql(d). (MYODBC and mysqlaccess)I would > > like to inquire, what do you mean. I don't comprehend what you just said. > > Please someone give more specific details... > > > > thanks, > > John > > > > -----Original Message----- > > From: Dan Nelson [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, April 04, 2002 8:42 PM > > To: Bill Easton > > Cc: [EMAIL PROTECTED] > > Subject: Re: accessing MySQL database from Access > > > > > > In the last episode (Apr 04), Bill Easton said: > > > I have a bunch of users with a MySQL database on their local > > > machines. > > > > > > Life would be simpler if they were able to access the MySQL database > > > (read only) from Microsoft Access. > > > > > > Can this be done through an ODBC connection? Can somebody tell me > > > how to set it up? > > > > Just install myodbc on the windows machines, set up a DSN pointing to > > the MySQL server, and link the tables in your Access project. > > > > -- > > Dan Nelson > > [EMAIL PROTECTED] > > --------------------------------------------------------------------- > 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 --------------------------------------------------------------------- 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
