I'm using a remote view to work with a table in an Access 97 .MDB. I have the latest MDAC installed (2.8) and Jet drivers (4.0 SP8). Connecting via ODBC. Everything is on a local HD.
The view opens fine, I can read the data and populate a local cursor. I make mods to the cursor, then write the results back to the view row-by-row using REPLACEs.
If I tablebuffer the view before starting the REPLACEs, then TABLEUPDATE() when I'm done, the process runs without errors, but the .MDB doesn't get updated at all. The date/time stamp on the .MDB is exactly the same as before the "updates". FC confirms that the original and "updated" files are identical.
If I don't tablebuffer the view, the REPLACEs for the first row in the view proceed OK, but as soon as the record pointer in the view is moved to the next row for the next set of REPLACEs, I get an ODBC error:
Connectivity Error: [Microsoft][ODBC Microsoft Access Driver]String Data, right truncated (null)
Ideas, anyone?
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up
