access database connection string problem

[skurge]

hello, I am using this connection string for my program.

"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=U:\\nx1\\Ufunc_Database\\dayton.mdb;";


This access 2000 database file is being stored on my company's network. My office has various workstations with windows 2000/xp. I can only connect to the database on the windows xp machines. How can I connect to database so that it will work across machines from the same network location?

[buser]

?
local: c:\...\file
remote:
\\ computer \ share \ file
but your account have to have permissions for access to this...

[skurge]

I found the problem. My database is Access 2002. It must have a jet 4.0 client to be able to connect to it. All of the clients on win2k have access 97. I found a msdn article. I installed jet drivers and mdac 2.8. After that, it worked fine.

skurge