Access Database
Article Reference NumberAA-00225 Views3087 0 Rating/ 30 Voters

How do I upload my Access database to the server?

  1. Create your files and save locally.
  2. Use our File Manager (located in Control Panel) or get a good FTP client, like FileZilla.
  3. Connect to your server using:
    • Host Name: ftp.domain_name.com or 168.144.xxx.xxx
    • Username: username
    • You know your password, leave other fields at their defaults.
  4. You'll see the files on the server on the right side of the screen and your local files on the left. Change the left directory to the directory on your computer that you saved your files in. Change the directory on the right to the /fpdb or /cgi-bin by double clicking on it.
  5. Select the files, and drag & drop them to the right side. It will upload the files.


NOTE: The following information is required:

  • domain_name.com = Use your own domain name.
  • 168.144.xxx.xxx = Use your own IP number (If your domain name is not pointing to our name servers yet)
  • username = Use your own username.
  • password = Use your own password.
  • Database must be under the /fpdb or /cgi-bin directories. Currently you have the write permissions to /cgi-bin and /fpdb directories but we can give the "write" permissions to another directory of your choice. Please contact us at support@myhosting.com

How can I connect to my Access DB using an OLE DB or DSNLess connection string?

We are using the latest Microsoft Data Access Components as well as the Office 2007 System Driver. Therefore all Access Database versions are supported. This is how you can make the connections:

Assumption: your database is in cgi-bin directory.

Access 2003 or Earlier Databases

DSNLess connection

<%
set conn = server.createobject("ADODB.Connection")
conn.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=e:\inetpub\clients\domain_name.com\cgi-bin\database.mdb"
%>

OLE DB Method

<%
set conn = server.createobject("ADODB.Connection")
conn.open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=e:\inetpub\clients\domain_name.com\cgi-bin\database.mdb"
%>

- or -

<%
set cnn = server.createobject("ADODB.Connection")
conn.Open "PROVIDER=Microsoft.ACE.OLEDB.12.0; DATA SOURCE="e:\inetpub\clients\domain_name.com\cgi-bin\database.mdb")
%>

Access 2007 Databases

<%
set cnn = server.createobject("ADODB.Connection")
conn.Open "PROVIDER=Microsoft.ACE.OLEDB.12.0; DATA SOURCE="e:\inetpub\clients\domain_name.com\cgi-bin\database.accdb")
%>

File DSN Connection Method for Access

<% set cnn = server.createobject("ADODB.Connection")
cnn.open "FILEDSN=AccessDSN"
%>

Error message: "Database - Not enough space on temporary disk"

Microsoft OLE DB Provider for ODBC Drivers error '8007000e' [Microsoft][ODBC Microsoft® Access Driver]

Not enough space on temporary disk error refers to the temporary space located in your database itself. It has nothing to do with the actual hard disk space on the server.

There are several gigabytes of space available on the server, so the problem is related to your database. To fix the problem; download it, compact & repair the database in Microsoft Access and then upload it back to your site.

How can I compact and repair my database?

To Compact and Repair a Database, please do the following:

  1. Open your database.
  2. In the Tools menu select -> Database Utilities -> Compact and Repair Database

Error message: "Database - Unable to open registry key Temporary -volatile- Jet DSN"

The [Microsoft][ODBC Microsoft Access Driver] General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xc0 Thread 0xfb DBC 0x250e014 Jet' error message is created when the database you specified in the connection cannot be found or opened. Check your code and make sure you have the correct path.

You can use Server.Mappath method or use the direct physical path. The path to your home directory will be:

e:\inetpub\clients\domain_name.com\

"Error-cannot update. Database or object is read-only."

While using ASP pages, you may encounter one of the follow errors messages:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Can't update. Database or object is read-only.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.  

These errors appear when an ASP script tries to access a database that doesn't have read/write/modify permissions set for it.

When a hosting account is first created, only /cgi-bin and /fpdb directories are given read/write/modify permissions. We suggest that you place your database in either of these two directories so that ASP scripts and write to the database. These folders also have the added security of not having "web read" access, meaning that a visitor is restricted from being able to download the entire database as they could a webpage.

If you need read/write/modify permissions applied to another directory, please send an e-mail to [1] and specify the path of the directory you wish to change.

Error: Could not update-currently locked by user 'admin'

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Could not update; currently locked by user 'admin' on machine 'web@@@'.

We suggest checking your scripts. You may be opening an exclusive connection, which will lock the database.

Does the server support multi-language in the database?

Multi-languages are supported by our servers, however Microsoft® Access 2000® is configured from all the local settings of that server (i.e. regional settings). All servers are currently set to U.S. settings. To alleviate this problem, we recommend that you use Microsoft® Access 97®, which does not rely on the server's regional settings. Alternatively, you can use the Unicode equivalents of characters in your language (i.e. "?" corresponds to characters in Turkish).

Comments(0)
There are no comments for this article.
Info Add Comment
Nickname: Email (will not be shown): Subject: Comment:
Info Vote