List:General Discussion« Previous MessageNext Message »
From:john Date:April 5 2002 2:33pm
Subject:RE: accessing MySQL database from Access
View as plain text  
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:dnelson@stripped]
Sent: Thursday, April 04, 2002 8:42 PM
To: Bill Easton
Cc: mysql@stripped
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
	dnelson@stripped

---------------------------------------------------------------------
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 <mysql-thread105196@stripped>
To unsubscribe, e-mail <mysql-unsubscribe-john=acculock.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


Thread
accessing MySQL database from AccessBill Easton5 Apr
  • Re: accessing MySQL database from AccessDan Nelson5 Apr
    • RE: accessing MySQL database from Accessjohn5 Apr
RE: accessing MySQL database from AccessBill Easton6 Apr
  • Re: accessing MySQL database from AccessYvon Darang12 Apr