I need to open a database on a user machine using an ASP app running on an IIS5 server. The DB will not reside on the server with the ASP files. The user machine is win 2000 or XP, but is not setup with IIS loaded.

My current connection in the ASP script is this:
testsConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:/test/test.mdb"

This is the error I get:
Microsoft JET Database Engine error '80004005'

"c:\test\test.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides."

It appears the ASP script (JET driver) cannot find the file on the local c: drive of the user.

Can this be done? How would I do this?

Thanks for your help,
Cookster

you should be able to use files on client side. but you need to make sure you use client-side script, VBScript or Javascript, instead of ASP codes, i.e. don't use codes reside <% %>.

I didn't think of that. I knew it, but I was so focused on ASP, client side VB script didn't occur to me.

Thanks again