Search
 
For more support
Enter your question or search term
  
eg. 'what are my email server settings'
 
 
Call 1800 995 645
 

Can I use an Access database

If your website is hosted on a Windows server, you can upload or write scripts that access or store data in an Access format database.

This can use a DSN (aka Data Source Name), which we can set up on the Windows server for you.

Alternatively you can use what is known as DSN-less connection, but your script must support this.

To have a DSN created for your Access database on a Windows server, first upload the database.mdb file to the location you want under your webspace, then contact support@ilisys.com.au with details of your account name and this database name. Generally we will call the DSN username_db, where username is your primary username.

If your scripts need to write to the database, contact Technical Support (support@ilisys.com.au or 1800 995 645) to get the correct permissions set for the database.

Note, the use of Access databases created with Microsoft Access 97 is not supported due to problems with the current MDAC drivers and Access 97 databases under load. Please create your database with Access 2000 or better.