Remote Access databases

[Feetstink]

I'm new to asp, but I have done some work with VB. not much. we're using multiple Access databases located on several different machines on the network. I want to query each of those databases on an asp page being served off my localhost, but when I try to give the location of the db's the way I do in the VB version,("Y:\abc\abc.mdb") it doesn't work. Is there another way I have to do this? The page works when I copy an .mdb to the local directory, but I can't do that with all of them. thank you.

[tvssarma]

Why dont you try creating a DSN and using it in the connection string

[JoshT]

AFAIK, mapped drives work for the locally logged in user, not a service account like IIS would use. Use \\ServerName\ShareName\filename.ext type naming convention to access the shared folders, and there are security issues - the account IIS accesses the shared folder with needs permissions set, etc.