-Using Access97 to connect to an ODBC database on an NT server (SP6) with the Visual Fox Pro driver.
Linking tables leads to "Couldn't execute query, couldn't find linked table [table name]." The table is present.
Updating MDAC to 2.6 helped briefly, but didn't correct problem on all workstations. In one case, the table could be viewed from the workstation, but after closing and reopening Access, the table appeared empty.
Workstations are Win98, all with MDAC 2.6 now.
What should we look at to correct this?
Linking tables leads to "Couldn't execute query, couldn't find linked table [table name]." The table is present.
Updating MDAC to 2.6 helped briefly, but didn't correct problem on all workstations. In one case, the table could be viewed from the workstation, but after closing and reopening Access, the table appeared empty.
Workstations are Win98, all with MDAC 2.6 now.
What should we look at to correct this?