Hello all
I have a database that needs to be updated through a website. I was told ASP might help me. Will VBA for Access work in ASP? Can someone put an example up that builds a connection from a host website to a database on my computer and how I can run a simple update query? I am totally lost when it comes to Updating, Appending or connecting to Access from the web. Thanks for you help!

Ant

Here an example of connecting access db to asp.

Dim DB
Set DB=Server.CreateObject ("ADODB.Connection")
DB.Open ("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE="+ Server.MapPath("quiz.mdb"))

Dim RS
Set RS=Server.CreateObject ("ADODB.Recordset")
RS.Open "SELECT * FROM ["&varData&"] ORDER BY ID ", DB

got it?