HELP!! can not connect to access across network

[matt]

Hello, I am using the following connection string, with
an access 2000 database file.

"Provider=Microsoft.Jet.OLEDB.4.0; Data Source =
U:\\Ufunc_Database\\dayton.mdb;"

U is a network drive. I can only connect to the database
on machines running windows xp. Other people on the
network running win 2000 receive a database error tring
to connect to the file. Does anybody know why I can
connect with winxp but not win2000? I am using the
database file in a simple C++ dialog on network. Could
it be some libaray file need to be updated? Does the
clients need have the same version of the jet?

 

[Douglas J. Steele]

You don't need double slashes. Try

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=U:\Ufunc_Database\dayton.mdb;"

Of course, this will only work if they've got their U: drive mapped
appropriately. If they may not, then try using a UNC, where you have
\\Server\Share\Ufunc_Datebase\dayton.mdb. (Replace Server and Share with the
appropriate values)