Can i make Access Front-End Web based

Hi champs,

Do you know the difference between MySQL and Access.

MySQL is a server-based DBMS. Which means it is designed to run on a dedicated, remote box and talk to other applications. The main interface is not local but over the network.

MS Access is a file-based DBMS. It is designed to sit on a local hard drive or at most a networked drive and be accessed using the file system and local client applications. Furthermore, there is very, very poor support for concurrent users, network hiccups, etc, etc.

What this means: there is no such thing as a hosted access DB.
Potential workarounds:

1: Access does support some builtin replication facilities. This would probably be the best way, should you stick with access.

2: Upsize the access DB to a MSDE database with an Access frontend. Setup a VPN connection between the two parties, and have them both access the same data using the access frontend. Relatively easy aside from the VPN angle. Remote user might have some speed issues as well, though that really depends on the connection and the design of the DB.

3: Take data from access DB. Using Access (bad idea) or another DBMS, make a web-based application for doing whatever it is they are doing. Probably best in the longer term if this thing is ever going to scale up significantly.