The different ways of "ASP" link Access2007 and Access2003

Microsoft this guy likes to change the program, programming language, file structure to change.

If your database is Access2007 can be directly as, through the Access2007 in the Save As, the database directly into the ACCESS2003 database *.mdb

But at the same time notice that your ASP links to the parts of access, you must from

ASP link Access2007:

<%db= "Database.mdb" Set conn = Server.CreateObject ("ADODB". Connection ") Conn. Open "Driver={microsoft Access driver (*.mdb)};p wd=admin;dbq=" & Server.MapPath (db)%>

Change to ASP link Access2003:

<%set Rs=server. CreateObject ("Adodb.recordset") Set Conn=server.createobject ("Adodb.connection") Conn.Open "DBQ=" &server. MapPath ("Database.mdb") & ";p assword=admin;driver={microsoft Access DRIVER (*.mdb)}"%>

Where Database.mdb is the database to link to. Password is the password for the Access database.

The different ways of "ASP" link Access2007 and Access2003