Hi

Here is the connection string I am using:

Provider=Microsoft.Jet.OLEDB.4.0;
Data Source="C:\Documents and Settings\daniel\My Documents\DanHarker's Site\agony_aunt\lexy.mdb";
Persist Security Info=False

Which was generated by Dreamweaver 8. When I try to test it, it says "Format of the initialisation string does not conform to the OLE DB specification". What am I doing wrong?

I don't know if it will solve your problem but you are using a ' inside the string what will give you problems. In my opinion NEVER use any sign in a path or filename even no spaces.

I think that a datasource that uses the Server.MapPath will work (not using DanHarker's Site)

<pre id=code><font face=courier size=2 id=code>
Provider=Microsoft.Jet.OLEDB.4.0;
Data Source="C:\Documents and Settings\daniel\My Documents\DanHarker's Site\agony_aunt\lexy.mdb";
Persist Security Info=False
</font id=code></pre id=code>

<hr><b>DMXZone support manager</b><br><a href="www.kousman.nl">Kousman web resellers</a>

Okay, Renamed my folder and removed the apostrophe. Server.MapPath did not work unfortuneately.

Here is my string now:

Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=C:\Documents and Settings\daniel\My Documents\DanHarkers Site\agony_aunt\lexy.mdb;
Persist Security Info=False

It is now saying the path is invalid.