DATABASES
  MS Access

Using Microsoft Access
All our Win2000 based servers have full support for Microsoft Access databases.

You can connect to your database:
  - via ODBC
or
  - via file DSN
  * global.asa file example using ODBC
  * global.asa file example using database path

You can also use DSN-less connections.
DSN-less connections are faster than System DSN connections because DSN-less avoids doing a registry lookup. Furthermore you can receive additional performance benefits by directly using the OLEDB layer.

Here is an example:
Dim Conn, dbPath
dbPath = "D:\webspace\hostname\username\yourdomain.com\www\youraccessfile.mdb"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & dbPath

Or you can use server map path:
Set MyConn = Server.CreateObject("ADODB.Connection")
conString = "DBQ=" & Server.MapPath("YourDatabase.mdb")
Myconn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & conString

You can find the physical path to your virtual website using the following code, view code.

---

<< back