By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,306 Members | 1,621 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,306 IT Pros & Developers. It's quick & easy.

Shared MS Access Database

P: 3
I would like to use an access database as a shared database on a remote website. I don't know if it is possible, but this is what i would like to do with this database:

- Use it to run a database driven website
- Maintain it via a client application and via the website.

As i would like to maintain it both locally and remote via website forms written in ASP, I don't want to sync the information between the server and a client database.
I would like the client application to maintain the remote database live as if it was a local database.

I would like to know if it is possible to use for example a VB application on a client computer to maintain the access database as if it was a local database.

If it is possible to run a database driven website based on the data in the database while it is being maintained via the client application. This means that locking shouldn't be an issue. A customer must be able to consult the website information which is pulled from the database even if that record is currently maintained. (eg as long as the changes aren't saved, the website shows the current information, when saved the website shows the new information)

This should work the other way around also. When a customer logs in to the website and changes his order online - and so updates the access database via the ASP form - one should be able to read this updated record immediately via the local client immediately after the clients update.

Is it possible to read/write/delete records live in a database both via ASP form and local client application without having locking issues as the information from the database is pulled for website displaying purposes.

Technology used via

- a simple access database
- ASP (not ASP.NET) to run the forms on the website
- VB written client application

How would I be possible to access the remote Access DB with a VB client application as if it was a local database?
As the database is on a remote web server I am unable to install something on the webserver.

OR is this only possible when working with MySQL database
and eg PHP as website script language.

Jul 7 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.