I have an ADO data control with a grid and textboxes bound to it. Everything works fine when running XP, but when running 2000, the grid retrieves the data but the textboxes don't.
.CursorLocation = adUseServer
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Persist Security Info=False;" & _
"Data Source=" & DatabaseName()
.Mode = adModeReadWrite
mrsTimecards.Open "SELECT * FROM Timecards", mconnTest, adOpenKeyset, adLockOptimistic
Set datTimecards.Recordset = mrsTimecards
I also tried bypassing the data control and binding the controls directly to the recordset:
Set grdTimecards.DataSource = mrsTimecards
Set txtEmployeeName.DataSource = mrsTimecards
txtEmployeeName.DataField = "EmployeeName"
which also works with XP but not with 2000. I have service packed 2000 and installed the latest MDAC and Jet Components. Still no dice.
MSADODC.OCX and MSBIND.DLL have been installed and registered.
I have also tried using a client-side cursor with no luck.