DreamWeaver MX 2004|ASP|Access!OLE DB Connection
Help!
I'm trying to connect to the sample Trio.mdb (using the sample help in DWMX) and don't understand what format I should be entering for the DSN. I know in windows the path format would be c:\xxxx\xxx\trio.mdb, but under the Mac OSX (which I am competely new to!) operating system I don't have a clue as to what format it is expecting, here is what I have attempted so far:
Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=Macintosh HD:Users:neilshawatabase:Trio.mdb;

and

Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=/applications/Users/neilshaw/Database/Trio.mdb;

All I get back is 'An unidentified Error has ocurred' , and the help just tells me to check the pathname. I have doubled checked that the mdb is in the correct place. I wish to user Access as the DB because I have been using it for years, instead of swiitch to a different type of DB.

Many thanks.

Neil