Where Am I?

snitz_forums_2000.mdb is used as an example database name.
If you have changed the name of your database, you'll need to change it in the strConnString example shown below, as well.

Physical Path to Database: D:\Inetpub\vhosts\msgltd.co.uk\httpdocs\data\snitz_forums_2000.mdb

Example strConnString:

This one will work with either Access97, Access2000 or Access2002:

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Inetpub\vhosts\msgltd.co.uk\httpdocs\data\snitz_forums_2000.mdb" '## MS Access 2000

Use the following only if you can't get the first one to work
One reason could be that your host doesn't have the MSJet Drivers installed:

strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=D:\Inetpub\vhosts\msgltd.co.uk\httpdocs\data\snitz_forums_2000.mdb" '## MS Access 97