Access
Connecting to an Access Database Using File DSN and ASP/ADO
This example describes using File DSN and ASP/ADO to connect to an Access Database. For help connecting to your Database with Alias Domains, see Finding Your Hosting Account’s Absolute Path.
Replace the db_ fields with the information for your database from the Control Panel in your hosting account. For more [...]
Setting up an Access Database for Your Hosting Account
Our Windows hosting accounts allow you to set up Access database support. Using the Control Panel in your hosting account, you can automatically create an "access_db" directory where you can upload your access database files.
To Set up an Access Database for Your website
Log in to your [...]
Removing Databases from Your Hosting Account
If you no longer need to use a database, you can remove it from your hosting account.
Connecting to an Access Database Using ASP/ADO
This example describes using ASP/ADO to connect to an Access Database.
NOTE: This code requires full trust and will not work on hosting accounts running ASP.Net 2.0/3.0/3.5/4.0.
<%
Dim oConn, oRs
Dim qry, connectstr
Dim db_path
Dim db_dir
db_dir = Server.MapPath("access_db") & “\”
db_path = db_dir & "yourdatabasefile.mdb"
fieldname = "your_field"
tablename = "your_table"
connectstr = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & [...]
Managing Your Hosting Account's Databases
After you’ve created your databases, you can manage them in the Hosting Control Center.
Importing Data from MS Access to MS SQL
Currently, this procedure is not supported. However, there are methods to migrate Access information to an SQL database. Please consult the documentation for Microsoft Access to determine the method that will work best for you in obtaining SQL compatibility.
For more information, see [...]
How Many Access Databases Can I Have On My Shared Hosting Account?
You can have as many MS Access databases as you can upload.
Caution: Large and multiple databases use significant amounts of memory to run and can slow down your site.
For more information about Access databases, see Setting Up an Access Database for Your [...]
What Do I Do When I Receive an Updateable Query Error?
Error Message:
Operation must use an updateable query. /file.asp 12
Cause:
The most common reason this error is generated is the database or directory containing the database you are trying to access does not have the correct permissions.
Resolution:
Either move the database to the "access_db" directory or add read/write permissions to the directory where [...]
3 min expected wait time