Online access model

[meltingpot]

Can anybody help.. this is the task.

I have an Access Db that is used in our office. The interface is web based using ASP classic - not Dot Net.

I now require our clients to logon via our public web site and manage their own details directly form this local Db. We have all the usualy security setup including a Cisco hardware firewall solution.

Do I have to have a seperate Access Db that sits on a server in a DMZ and sync with the internal databse ?If it does sync it needs to do it on everychange. Not setup a sync before and the MS documents dont seem to be clear.
Has anybody a good working model for this.

 

[jrbarnett]

If you were doing this, I'd seriously consider moving the data to a client/server system such as SQL Server Express or MySQL.

This way, your ASP web server can have connectivity to the database server enabled in the firewall (this can be internal, only the web server component needs to be externally accessible).

Internet
|
Firewall (enable port 80 or 443 to web server in DMZ as appropriate)
|
Web Server running ASP code
| (connect through SQLOLEDB or ODBC connection)
DB Server (this not need be in the DMZ itself; it just needs to be able to communicate with the web server.

Within your office, your PCs can connect directly to the DB Server if they need an Access hosted front end application or use the web server management directly.

John