Need to add records to our WEB site Access db from local db

[DougP]

Need to add records to our WEB site Accdb
We don’t have the luxury of updating to SQL server.
Currently I open the WEB site in Front Page, double click the Acc db its /fpdb folder.
There are linked tables in that database so after it’s double clicked and a temp copy is loaded the linked tables can then see our server such as F:\blahblah\dbname.mdb
I then run a query in that db which creates the records.
Then I close the db and its new records are then copied up to the WEB site.

How can I automate this without using Front Page.
Any ideas welcomed? Vbscripts etc.
Currently I can’t seem to open the database using

http://www.ourwebsite.com/fbdb/mydatabase.mdb

in vbscript or in Access itself or using ODBC


DougP
< I Built one

http://www.robots2000.com

 

[Remou]

Why not ASP/ASP.Net?

 

[fneily]

What version of Access? If 2000 - 2003, maybe create DAP's (Data Access Page). That's the Page Object in the Access Database.