Help | Feedback | Site map  
Login  
Password  

Help index
Billing & Administration
Windows Virtual Servers
UNIX Virtual Servers
Email
Logs & Statistics
Getting started
 
16/12/2018  

 

Microsoft Access databases

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 and given the special file permissions on the /private folder allows your scripts to write data to the database.

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 Con = Server.CreateObject("ADODB.Connection")
conString = "DBQ=D:\j\o\joebloggs\private\database.mdb"
Con.Open "DRIVER={Microsoft Access Driver (*.mdb)};" & conString

'joebloggs' being your HOSTING account name and 'j' and 'o' the first and second characters of your HOSTING account name. Note that when your account is accessed via the SSL secure server, the full path is different, see the SSL page for more information

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  |   Hosting  |   Domains  |   Contact us |   Help  |  

Copyright, Sipero.com, 2002. All right reserved. Please, read our Privacy Policy , Terms of service