24/7 Support /Email Us

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.

Copyright © 2016 | Designed & Developed By A2A PRODUCTION
error: Content is protected !!