Re: Using Access to Connect to Online Databases

[Stefan Hoffmann]

hi,

jo****@irvinemail.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]

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 <[e-mail]>
wrote:

hi,

[e-mail] 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]

hi Joseph,

jo****@irvinemail.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]

hi Joseph,

jo****@irvinemail.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 <--