Update Access database over the internet

[CBuxton]

I would like to know if there is an easy way to update a Microsoft Access database over the internet. I have a site that I run for a company and we use MS access as a place to keep track of order status'. Using Frontpage I setup a page that runs a query on the table and gives order status depending on the customer who logs on. Anyway, I'm looking for a way that I can have the people at the company update the Access database with order status information (on of the fields of the DB) over the internet. Access can generate a REALLY nice webpage (using the pages object), but I am not able to access that over the internet. Any ideas for me? Thanks!

 

[CBuxton]

bump

 

[Turkey]

One way to update the Access database is to create a form that posts to an ASP. In the code, you would verify the data. If everything checked out ok, you would use ADO to update the database. Search MSDN Online for information about ADO and ASP if you used either before. To use ASP, you have to have an ASP enabled web server (IIS, PWS, Apache with ChiliASP, etc...) and to use ADO, you have to have ADO installed.

Anyway, that's one way to do it

 

[iDazzler]

In my opinion, the easiest way to update an Acess database is through ASP. A good starting point would be Visual Interdev. Interdev will generate most of the code for you. Once the code is generated look it over.

A good ASP is 4guysfromrolla.com or 15seconds.com

Best of Luck.

 

[CBuxton]

Thanks for your responses. I'll look into it!