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 the database resides.For more information [...]
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 website.
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.
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 What is the absolute or direct path for my Windows (ASP) hosting account?.
<%
Dim oConn, oRs
Dim qry, connectstr, sDSNDir
Dim db_name, db_username, db_userpassword
Dim dsn_name
dsn_name = “your_dsn_name”
fieldname = “your_fieldname”
tablename = “your_tablename”
‘assumes that _dsn exists [...]
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.
<%
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=” & db_path
Set oConn = Server.CreateObject(”ADODB.Connection”)
oConn.Open connectstr
qry [...]
Our Windows hosting accounts allow you to set up Access database support. Using the Hosting Control Center, you can automatically create an “access_db” directory where you can upload your access database files.
NOTE: If you enabled ColdFusion after September 23, 2009, you cannot use an Access database.
To Set up an Access Database for Your websiteLog in [...]