|
Microsoft Access Databases
Microsoft Access Databases can be placed on our Windows 2003
servers for use with your ASP and ASP.NET pages.
Uploading Your Database
You should upload your database file created with Microsoft Access to
the /private directory within your web space, your database file should
have the extension .mdb. Uploading your database to the /private folder
allows your scripts to access the data within it without allowing internet
users to download your entire database file.
Connecting To Your Database
You should connect to your access database using a DSN less connection.
You might use code such as the following:
Set Conn = Server.CreateObject("ADODB.Connection")
conString = "DBQ=D:\j\o\joebloggs\private\database.mdb"
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)};" &
conString
Where D:\j\o\joebloggs is the path to your home directory which can be
obtained from the File System support
documentation and your database file is named database.mdb and resides
in the private folder within your account.
DSN less connections are faster and more efficient than ODBC connections
since they avoid the need for a registry lookup, for this reason, ODBC
connections for Access databases are not supported.
|
