Access Database via ASP

[Blue Dragon]

Hi,
I've get a database set up that can be controlled via ASP. I currently connect to it using:

Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("tracker.mdb")

Now, I want to add some fields to the table within in. Unfortinately I can't simply edit the database on the server because the database was originally created in Access 97, and we've subsequently upgraded to Access 2003.
If I convert the file to Access 2003, the above ASP will not work.

Can someone tell me either (a) how to connect to a 2003 version using an analogous method to above, or (b) tell me how to edit the database using ASP?

Thanks.

 

[huh?]

Blue,

Please include more info as follows:
Working Application-
1)OS of server
2)IIS 5 or 6
3)MDAC installed? version?
Broken Application
1)See above
2)See above
3)See above
4)Most importantly the error message when it tries to connect

 

[skaas]

Try one of the following useful links

http://www.powerasp.com/content/database/default.asp

http://www.aspin.com/home/tutorial/database/edit

Alternatively you could join up to ASPFree Forums

www.aspfree.com

Most programmers here use ASP to manipulate thier databases

Hope that helps