"JD" <JD@discussions.microsoft.com> wrote in message
news:AF07A03F-BBC1-46F7-9FBD-2BB31115F6FF@microsoft.com...
> hello,
>
> Using VBScript to connect the Microsoft Access Driver (.mdb) file getting
> error on Vista, but it is working on XP
>
> connstr="Driver={Microsoft Access Driver
> (*.mdb)};Uid=xx;Pwd=yy;Dbq=c:\users.mdb;"
>
> The following error using Vista
>
> "[Microsoft][ODBC Microsoft Access Driver]'(unknown)' 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."
>
> Could you please give some solutions /suggestion to fix this error?
> http://www.google.com/search?q=%22%5...&start=10&sa=N
I would suspect that what is needed for the solution to run on XP is there,
and it's not there in the same manner on Vista. You might have a versioning
issue in using MDAC between the two O/S(s) or it might even be a security
issue on Vista.
You have heard of the Vista UAC manifest that a program may need to use to
present security credentials for an application running on Vista? Use Google
and look up information about the UAC manifest on Vista that a program may
need to use.
You cannot expect that something that runs on XP is going to run on Vista,
without some possible tweaks.