HELP!! can not connect to access across network

  • Thread starter Thread starter matt
  • Start date Start date
M

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?
 
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)
 
Back
Top