Script Tips


NetBizCity - Script Tips
Monday, 09 October 2006 03:15

Dealing with an Access database on the WEB

How to maintain an Access Database on the WEB

If you are setting up a Internet or Intranet site and really don't need to use SQL Server or Oracle as your database - Access may just do the trick.
The only problem is when you need to modify the database or import data.
The question becomes how do you do it.
You don't want to overwrite the database file because this can be a problem.
Should users be logged on at the time you decide to replace it you will run into trouble.

The best way is to use a remote access utility. There are a few on the market that serve this purpose but you might want to look into a product called Cute ASP Table Editor.

This one can be downloaded free from:    http://sourceforge.net/projects/cuteasp/

Published in Windows