someotherdude
Programmer
I have database in multi user environment. I have splitted the database to front end and back end.
The problem is that sometimes Access deletes a record from one table (always the same table). The situation when this happens is usually this kind:
On a form there are records from one table. Records to the form are choosed by a select query. In records there is a YES/NO field. User clicks radio buttons (which are bound to this YES/NO field) to set values to YES.
After that user clicks a button which starts a report (this is the moment when deleting usually happens). It doesn't happen every time, maybe about every 20th time. The report is based on a select query. The query selects to report records which have YES in the YES/NO field.
After deleting the record has #Deleted in every field of that record on the form. When I open the table there are also #Deleted in every field of that record. I can't remove the #Deleted-record. I have to Compact and repair.. that changes #Deleted to ############. After that I can remove the record and add the original record from back up. And now the db works fine again until...
If I try before repairing to do something which needs the table which has the #Deleted-record, Access says "Record is deleted".
-Deleting happens also when just one person is working with database.
-Simultaneous users max 3.
-Users have own user names and passwords (using .mdw).
-15 tables, in the biggest table there are about 200 records.
-Back end file size under 1 MB.
-NT 4, Access 2000. All computers with the same versions.
Any help would be greatly appreciated.
The problem is that sometimes Access deletes a record from one table (always the same table). The situation when this happens is usually this kind:
On a form there are records from one table. Records to the form are choosed by a select query. In records there is a YES/NO field. User clicks radio buttons (which are bound to this YES/NO field) to set values to YES.
After that user clicks a button which starts a report (this is the moment when deleting usually happens). It doesn't happen every time, maybe about every 20th time. The report is based on a select query. The query selects to report records which have YES in the YES/NO field.
After deleting the record has #Deleted in every field of that record on the form. When I open the table there are also #Deleted in every field of that record. I can't remove the #Deleted-record. I have to Compact and repair.. that changes #Deleted to ############. After that I can remove the record and add the original record from back up. And now the db works fine again until...
If I try before repairing to do something which needs the table which has the #Deleted-record, Access says "Record is deleted".
-Deleting happens also when just one person is working with database.
-Simultaneous users max 3.
-Users have own user names and passwords (using .mdw).
-15 tables, in the biggest table there are about 200 records.
-Back end file size under 1 MB.
-NT 4, Access 2000. All computers with the same versions.
Any help would be greatly appreciated.