We provides MS SQL Server 2000 access for an extra fee.

SQL Server 2000 is only needed if you require a back-end database solution for high throughput domains. It is a high-end alternative to using other databases such as Access, Foxpro and Dbase (which are all supported on Windows servers free of charge).

To administer an SQL Database you need to create your database live using Enterprise Manager or Visual InterDev. If you do not have either of these tools you will have to use .NET Enterprise Manager online which we provide at http://sqladmin.nshosts.com .

If you require us to run an SQL script to setup your database for you we are happy to do so, upload the script to your website, and contact support being sure to include explicit instructions on what is required and the location and name of the script.

.NET Enterprise manager is provided to administer your database online at http://sqladmin.nshosts.com .

We recommend using a DSN-less connection to your database, click here for exact syntax.

How to convert an existing Access database to a SQL Server database?

Microsoft provides a convenient tool in Access 97 or 2000 to upgrade an existing Access database to an SQL database. Click on the following links to download the tool and instructions on it's use.

Access 97: http://www.microsoft.com/AccessDev/ProdInfo/AUT97dat.htm

Access 2002: http://msdn.microsoft.com/library/techart/upsize00.htm

You will need to create a local DSN (on your computer) to upsize your Access database. For step-by-step instructions and screenshots click here .