Connecting to an Access database remotely

is this possible?

[giggle]

Hi

We operate a back office system that I developed using VB6.

Is it possible for me to connect to the Access database via the web so that I can handle customers remotely?

Sounds impossible (to me), but if it's not it would be great!

Any ideas gratefully received.

Thanks

Mick

[enkabe]

Try looking for "dbadmin", which lets you access your database using your web browser. I'm not shure if it is what you are looking for.

[giggle]

Thanks enkabe, reading my initial post I don't think that I explained my needs properly.

In one location is our server running the Access database I'm at home and would like to connect to the Access database directly via a VisualBasic program and my ADSL connection. Not using GoToMyPC or the like.

Sounds impossible, ah well...

[txbakers]

It's not impossible at all.

You would just need to write your own "portal" to handle the functions over the web. Perhaps in an ASP application.

It's just like writing any other web application, but this one helps you maintain the database.

[aspdaddy]

I dont think it can be done without a VPN or custom webservice. Which connection string could you use in ASP to connect remotely to Access?

ADO and ADO.NET connection strings [carlprothman.net]

You could enable RRAS on the webserver and remote in but you are running a big risk.

You would be better of setting up a IPSec Layer 2 VPN tunnel and configure the VB App to connect to a local IP Address, use a very restricted Windows account and strong password.

[txbakers]

You can use Access as a database for websites. That's what I was recommending, not a true GUI for access remotely.

Just create a user login/password for the ASP page and you can do updates, deletes, etc. like a web app.

[DatabaseForSale]

I will convert from Access to SQL server and then use it from multiple sites.

[Raymond]

I have never done this but...

You can use MSXML to open a file remotely, and since JET can run MDB files in whatever file extension, you can grab the file from the remote server, and then run it on your local server.

This is for sure not an efficient method since you have to download the DB EVERYTIME you attempt to access it, but I believe it will work if you must do this. By doing this you are leaving your DB open to public though.