Carnafex
Registered User.
- Local time
- Today, 14:55
- Joined
- Jan 19, 2004
- Messages
- 38
Really weird #Delete error
As of late my large database that I have written has started to recieve errors. Before last week though, it worked nicely, and its only been in the last couple of days when everythings begun to go banana shaped.
A quick bit of info; the Database is split to front/back end format, and due to our company's situation some of us are using access2000 and some are using access97.
The problem is that I have a simple form that records data into a table for some persons personal data. This worked well, but now some of the fields for some people (only a few) have suddenly deleted themselves. The fields in question are two memo fields, and have been replaced by a #Error if the person views it in access97, or a #Deleted if viewed in access2000.
If a person using access97 clicks on the field to try and edit it, its says something along the lines of 'The action has been canceled as another user is trying to access the data you are trying to change'. It repeats this error no matter how many times you click on it.
However, if the person is using access2000, when they click on the #Deleted field, nothing happens. You can type anything in, but when you try to save the record, it says 'Record is Deleted'. If you're in the form, all fields go blank, if you're in the table, every single record just vanishes and you cant move off the record. (By this I mean you can move left and right in the record, moving up or down is just canceled and set back to the field you came from).
As you can see, this problem is quite serious, and Im quite stumped for solutions. If any of you guys out there have a solution it would be greatly appreciated.
Thanks
Jason
As of late my large database that I have written has started to recieve errors. Before last week though, it worked nicely, and its only been in the last couple of days when everythings begun to go banana shaped.
A quick bit of info; the Database is split to front/back end format, and due to our company's situation some of us are using access2000 and some are using access97.
The problem is that I have a simple form that records data into a table for some persons personal data. This worked well, but now some of the fields for some people (only a few) have suddenly deleted themselves. The fields in question are two memo fields, and have been replaced by a #Error if the person views it in access97, or a #Deleted if viewed in access2000.
If a person using access97 clicks on the field to try and edit it, its says something along the lines of 'The action has been canceled as another user is trying to access the data you are trying to change'. It repeats this error no matter how many times you click on it.
However, if the person is using access2000, when they click on the #Deleted field, nothing happens. You can type anything in, but when you try to save the record, it says 'Record is Deleted'. If you're in the form, all fields go blank, if you're in the table, every single record just vanishes and you cant move off the record. (By this I mean you can move left and right in the record, moving up or down is just canceled and set back to the field you came from).
As you can see, this problem is quite serious, and Im quite stumped for solutions. If any of you guys out there have a solution it would be greatly appreciated.
Thanks
Jason
