richard1458
Instructor
I have designed a database currently used by myself and two colleagues. We all have our own sets of data, which is exported from a main database to which we only have access when 'in the office'.
The code/queries which import and check the data compares certain information from the 'main' and the 'local' database, and alerts the user if changes are made (e.g. to the dates of meetings) and then asks, via a form, for confirmation.
This runs fine on my machine, but on my colleagues' machines, although records ae returned correctly the error message 'recordset is not updatable' is produced. (Same version of Access - 97). I have checked that both the form and the underlying query are set to 'Dynaset - inconsistent updates'.
Any suggestions? Some of the fields returned by the query may have Null values in my colleagues' data, where they are zero-length or false in mine.
Thanks,
Richard
The code/queries which import and check the data compares certain information from the 'main' and the 'local' database, and alerts the user if changes are made (e.g. to the dates of meetings) and then asks, via a form, for confirmation.
This runs fine on my machine, but on my colleagues' machines, although records ae returned correctly the error message 'recordset is not updatable' is produced. (Same version of Access - 97). I have checked that both the form and the underlying query are set to 'Dynaset - inconsistent updates'.
Any suggestions? Some of the fields returned by the query may have Null values in my colleagues' data, where they are zero-length or false in mine.
Thanks,
Richard
