lucbrebels
MIS
- Mar 13, 2004
- 2
Hi guys,
I need some help…
Situation:
- My application consists out one back end (tables) and one front end DB (queries, forms, etc). I’ve copied the front end to the hard disk of all users and placed the back end on a network drive.
- When the users open the front end DB they can choose between several forms on the switchboard (putting in new data, performing a search, changing existing records, show query results, …).
- For each form where users can add, change or delete records I’ve put record set on “Dynaset” and Record locks on “Edited Record”. For the forms where they can only view the data I’ve put the record set on “Snapshot” and Record locks on “No locks”.
- All users (6 persons) are using Access 2003
Problem:
When person1 is adding a record and person2 is doing a search at the same time (on the same table). Person 2 sometimes gets the message “Record is deleted” and then #Name? in all text boxes. If this occurs and I check the table behind the forms I see that all fields of the record person1 was entering are showing #Deleted. When person1 and 2 close their front end DB and open it again the problem is solved. The fields of the record person1 was adding are not showing deleted anymore and both persons can work again. The strange thing about this is that I happens sporadically…
Has anybody a clue how I can solve this?
Remark:
Because I’m using VBA I’ve also checked the VBA references of all users. Although the users have installed Access 2003 recently Access shows different versions (2.5, 2.6, 2.7 and 2.8) for reference “Microsoft ActiveX Data Objects Recordset Library”. Maybe this irregularity is a part of the problem… how can I fix this?
I need some help…
Situation:
- My application consists out one back end (tables) and one front end DB (queries, forms, etc). I’ve copied the front end to the hard disk of all users and placed the back end on a network drive.
- When the users open the front end DB they can choose between several forms on the switchboard (putting in new data, performing a search, changing existing records, show query results, …).
- For each form where users can add, change or delete records I’ve put record set on “Dynaset” and Record locks on “Edited Record”. For the forms where they can only view the data I’ve put the record set on “Snapshot” and Record locks on “No locks”.
- All users (6 persons) are using Access 2003
Problem:
When person1 is adding a record and person2 is doing a search at the same time (on the same table). Person 2 sometimes gets the message “Record is deleted” and then #Name? in all text boxes. If this occurs and I check the table behind the forms I see that all fields of the record person1 was entering are showing #Deleted. When person1 and 2 close their front end DB and open it again the problem is solved. The fields of the record person1 was adding are not showing deleted anymore and both persons can work again. The strange thing about this is that I happens sporadically…
Has anybody a clue how I can solve this?
Remark:
Because I’m using VBA I’ve also checked the VBA references of all users. Although the users have installed Access 2003 recently Access shows different versions (2.5, 2.6, 2.7 and 2.8) for reference “Microsoft ActiveX Data Objects Recordset Library”. Maybe this irregularity is a part of the problem… how can I fix this?
