RE: Server Mappath in Connection string for Access

Hi

Can and has anybody used a server.mappath to map an access database and use this method within a connection string?

got a pretty good idea, and it goes something like this.

VB Code:

Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=" & server.MapPath("http://path") & _ 
"Uid=HELLO;Pwd=WORLD;"

am I correct? or does this need correcting...

Cheers all

Kai

Server.Mappath returns a physical path on the server, so that wont work.

server.MapPath("accessdb.mdb")

Is what I use....