Hi, all
 I found a problem about connection to Access Database.
I build Custom Connection String with "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("\Northwind.mdb") and "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.Mappath("\Northwind.mdb"). when I click test button, it alert "Connection Successfully". the problem occur when I came back to Database Tab in Application panel. My Connection name was appear in list but It coundn't show table in this connection.
    I found this problem in some machine. I don't know why. Please help me to solve this problem.

Thank you in advance.
Kerati.

This is probably due to the fact that at design time, Dreamweaver cannot resolve Server.MapPath.

Try changing the connectionstring so it uses a local, fixed path like c:\Inetpub\wwwroot\YourSite\Databases\YourDatabase .mdb

Can you please not cross-post your messages in multiple forums?

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Dear, Imar

Really sorry about posting in another forum.

I tried to do every way include your suggestion. It didn't work. Sometimes I used same OS and same version (MX 2004 7.1) and same Database (Access XP) and same code, 2 machines was not the same (one did work and another didn't work).

Last Times before, I can use Server.Mappath in Dreamweaver MX 2004 smoothly. It didn't error. In my website
http://www.bus.mut.ac.th/board_com.asp
I use Server.Mappath to build this page via Dream MX 2004 too.
(sorry about my site, it 's thai language)

Oh, I forgot to tell about something

If I run same code outside Dream..... It work !. It can connect to database and can show data I want to know.

So I think it 's not concern about IIS or Database or my code..

I asked my friend, he did uninstall Dream and install it again. He can solve my problem but I can't.

have you got your connection file at the top of ytour page?



for example.