I searched and found 1 post which was not quite clear so I'll go ahead and ask...

I have dsnless database residing on a server that I'm trying to connect to. The way I understand it is that I need to add some code to the pages that will be using this database (access mdb). Dreamweaver MX's help gives this as an example:

Driver={Microsoft Access Driver (*.mdb)};
DBQ=C:\Inetpub\wwwroot\Academy\curriculum.mdb

(stupid question #1 - Where does this snippet of code go? I assume above &lt;html&gt<img src=../images/mxzone/forum/icon_smile_wink.gif border=0 align=middle>
(stupid question #2- How do I know the drive on a hosted account? all i see are a few folders- what path do I put in? database is in fpdb/database.mdb)

MX is still wanting me to setup a connection. (#3) Do I select Custom Connection String? (#4) What do I put in that dialog box?

I'm probably making this a lot harder than it is. I appreciate any help.

.GrillCheese

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I searched and found 1 post which was not quite clear so I'll go ahead and ask...

I have dsnless database residing on a server that I'm trying to connect to. The way I understand it is that I need to add some code to the pages that will be using this database (access mdb). Dreamweaver MX's help gives this as an example:

Driver={Microsoft Access Driver (*.mdb)};
DBQ=C:\Inetpub\wwwroot\Academy\curriculum.mdb

(stupid question #1 - Where does this snippet of code go? I assume above &lt;html&gt<img src=../images/mxzone/forum/icon_smile_wink.gif border=0 align=middle>
(stupid question #2- How do I know the drive on a hosted account? all i see are a few folders- what path do I put in? database is in fpdb/database.mdb)

MX is still wanting me to setup a connection. (#3) Do I select Custom Connection String? (#4) What do I put in that dialog box?

I'm probably making this a lot harder than it is. I appreciate any help.

.GrillCheese
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

#1: Under a subdir named "Connections"
#2: Use a string like this; "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("xx.mdb"

Good luck, Mats Lindstrom, Sweden