SUPPORT - ACCESS DATABASES


Email

Mailboxes
Email Forwarding
Auto Responders
Multiple Recipient Addresses
Default Mail Routing

Windows Virtual Servers
FTP
File System
Active Server Pages
Microsoft Access Databases
WAP
Windows FrontPage Extensions
Windows SSL
Microsoft SQL Server
URL Submitter

Logs
Usage Statistics
Disk Space
Data Transfer

Support Request
Technical Support Request Form


 

Microsoft Access Databases can be placed on our Windows 2000 servers for use with your ASP 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.

HOME     LOGIN     WEB DESIGN      CONTACT US     HELP      TERMS & CONDITIONS

Copyright © 2003 MaxVista Design Ltd. All rights reserved.
Username
Password