General discussion
-
Topic
-
Win 2K/ Access/SQL data loss
LockedData loss (data that got corrupted and disappears (ms-sql:data type=image, ms-access: ole object) in the following scenario:
? Server: Windows NT4 with SP6a and SQL Server 7.0 (7.00.961)
? Client: Windows 2000 Pro with SP2 and Access 97
The file C:\Program Files\Common Files\System\OLE DB\oledb32.dll has the following version number:
? Server: 2.10.4202.0
? Client: 2.52.6019.0
There was a recommendation that we should have the same version of MDAC (2.5) in both, servers and clients.
Questions:
1. We should expect any problem installing MDAC 2.5 in the WinNT4 server?
2. Do you have any recommendations?microsoft answer:
The version of MDAC on the server should have no interaction with the version of MDAC on the client. The client connects directly to the server, not through MDAC on the server.
There should be no problems installing MDAC 2.5 on the NT4 server, but that most likely will not solve their problem.