Re: Using Access to Connect to Online Databases

[Stefan Hoffmann]

hi,

joseph@irvinema il.org wrote:

Two questions, can this be done in Access, and, if so, how?

Nope, this is not really possible. The easiest way: use a MySQL or SQL
Express on your domain and connect to these using DAO.


mfG
--stefan <--

[joseph@irvinemail.org]

Re: Using Access to Connect to Online Databases

Hello,

So, can I use Microsoft Access as a portal of sorts if I have a MySQL
or SQL database?

I want them to be able to use Microsoft Access as if it were a local
database, designing and printing reports, queries, changing data, etc.
So can this be done with a DAO through Microsoft Access?

Thanks,
Joseph


*************** *************** *************** ************
On Apr 28, 9:16 am, Stefan Hoffmann <stefan.hoffm.. .@explido.de>
wrote:

hi,
>
jos...@irvinema il.org wrote:

Two questions, can this be done in Access, and, if so, how?

>
Nope, this is not really possible. The easiest way: use a MySQL or SQL
Express on your domain and connect to these using DAO.
>
mfG
--stefan <--

[Stefan Hoffmann]

Re: Using Access to Connect to Online Databases

hi Joseph,

joseph@irvinema il.org wrote:

So, can I use Microsoft Access as a portal of sorts if I have a MySQL
or SQL database?

Yes.

I want them to be able to use Microsoft Access as if it were a local
database, designing and printing reports, queries, changing data, etc.
So can this be done with a DAO through Microsoft Access?

Yes. You have just linked tables to your DB server instead of local
tables. Everything else remains the same.


mfG
--stefan <--

[Stefan Hoffmann]

Re: Using Access to Connect to Online Databases

hi Joseph,

joseph@irvinema il.org wrote:

So, can I use Microsoft Access as a portal of sorts if I have a MySQL
or SQL database?

Take a look at

http://www.mssqltips.com/tip.asp?tip=1480

mfG
--stefan <--