AM
> To: Jerry Schwartz
> Subject: RE: Ms access front end and mysql back end
>
> My database is in MySQL on the server and I have 5 machines
> connected to the
>
> server. The front end is MS access. This is where I have
> forms, queries,
> reports and macros. The front e
TED]
> Sent: Friday, January 19, 2007 4:44 AM
> To: Jerry Schwartz
> Subject: RE: Ms access front end and mysql back end
>
>
> My database is in MySQL on the server and I have 5 machines
> connected to the
> server. The front end is MS access. This is where I have
> forms, querie
You didn't give us much information. If you open the Data Sources
configuration, what happens when you test the connection?
Did this ever work?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Mes
Do the following in 'mysql' client:
select * from mysql.user\G
Does you user have all necessary privileges maked as Y ?
You may need to update your user's host field to '%'
to allow you to connect from any host other than localhost.
Don't forget run 'flush privileges;' afterwards.
Give it a try
