NewB: Connecting to Database?

[Rob]

Is there a way of connecting to a database on my server using Microsoft
Access.

I want to be able to modify my database without having to download it,
ammend it and then upload it back again

My account supports MySQL but i dont really know much about this

Any help will be appreciated

Many thanks

Rob

[Larry Linson]

As a start you might take a look at the presentation I did for my user group
on "Access as an ODBC Client" that you can download from
http://appdevissues.tripod.com/downloads.htm.

MySQL has available an ODBC driver called MyODBC. I haven't used it, but
others have reported doing so.

I am assuming you mean a server machine on your LAN, not a web server.
Accessing your database on a webserver is a bit more complex.

Larry Linson
Microsoft Access MVP
"Rob@" <ro*@robsREMOVETHISweb.karoo.co.uk> wrote in message
news:bm**********@newsreaderm1.core.theplanet.net. ..

Is there a way of connecting to a database on my server using Microsoft
Access.

I want to be able to modify my database without having to download it,
ammend it and then upload it back again

My account supports MySQL but i dont really know much about this

Any help will be appreciated

Many thanks

Rob

[Jay Bartol]

"Rob@" <ro*@robsREMOVETHISweb.karoo.co.uk> wrote in message
news:bm**********@newsreaderm1.core.theplanet.net. ..

Is there a way of connecting to a database on my server using Microsoft
Access.

I want to be able to modify my database without having to download it,
ammend it and then upload it back again

My account supports MySQL but i dont really know much about this

Any help will be appreciated

Many thanks

Rob

Visit MVP site:
http://www.mvp.org
Jay Bartol, MVP

[Larry Linson]

"Jay Bartol" wrote

Visit MVP site:
http://www.mvp.org
Jay Bartol, MVP

There is no Microsoft Access MVP named Jay Bartol. See the updated list at

http://mvp.support.microsoft.com/def...le=toc#faq1152

There is a Don P Mellon who posts this kind of response, and has taken to
using this one which causes pop-up after pop-up when you realize it is phony
and try to leave it.

Before, he would use the actual Access FAQ site http://www.mvps.org/access
(whether or not it had anything to do with the particular question, but it
is a good site with a lot of good Access information and, at least, it
didn't lure you into a chain of pop-up windows.