REMOTE Connection to Access DB

[sandra45]

Hi, I have a M.Access database residing at the server at the office. If I have an ASP page stored at my ISP company's server (another city), how to access the Access database by using the ASP either with ADO or RDO or better suggestion?

The reason for this is, to let users from anywhere to access my database.

Should I place my Access database under Inetpub

http://wwwroot

folder or can it be placed under Inetpub data folder, for example? And what type of sharing should I have in here?

Thanks.

Regards,
Sandra

 

[SatishPutcha]

Hi Sandra

I have never used RDO but I think that is one way of ways of accessing the MDB across servers.

However, I did it using another ASP page that will be on the same server as the DB. You send the information to that page(form post/get), it does the required operations and sends a response back.

This is roughly the method assuming of course that you can have access to put files on the server having the MDB.

Regards
satish