Record is Deleted ###### ?

[firebirdta84]

I have 30 users on a database...yesterday they are started getting the error, "Record is Deleted". I went into the main table and found a record that just had pound signs (#) in every field. What caused this, and how can I prevent it in the future?

Thanks,
Joe

 

[Remou]

Have a look here:

http://www.granite.ab.ca/access/corruptmdbs.htm

 

[firebirdta84]

I looked around that page earlier, but couldn't find what I was looking for...

I have the database set up on a shared drive where 30 users can access it...just need to know what caused this...they have the ability to delete records...maybe that caused some kind of conflict?

Joe

 

[Remou]

Have you split the database? Do you regularly compact and repair?

 

[firebirdta84]

Yes, the database is split and I compact and repair daily. The compact and repair did fix the problem, but I'd like to prevent it from happening in the future. It's only happened once so far...the users have the ability to delete records...could that be causing the problem some how?

Thanks,
Joe

 

[Remou]

That is unlikely, unless there are other factors. The link I posted is pretty much it when it comes to corruption issues, for example, did you determine which work station caused the corruption (

http://www.granite.ab.ca/access/corruption/workstation.htm)?

Did you go through the list of causes (

http://www.granite.ab.ca/access/corruption/causes.htm)?

 

[firebirdta84]

This problem started surfacing again yesterday and I don't know why. I have about 20 users on this database at any given time.

I have a main form that users enter info in. This is connected to the main table, called "tbl_Master", which has an AutoNumber Primary Key. The user can press a button to open another form to enter additional information. This other form pulls from another table with another AutoNumber Primary Key. Both tables are linked by a common field, called "Case_Number", which is a value the user enters. I read somewhere that the culprit may have to do with the AutoNumber Primary Key?

Would it be better to combine these tables into one large table, with only one AutoNumber? Would that affect the speed of the database if I put these two tables into one large one (consisting of about 25 fields total?).

Any help is needed and appreciated! A lot of this stuff is new to me so I apologize if my logic doesn't make sense.

Thanks,
Joe

 

[lespaul]

did you check out the links above? Were you able to determine which workstation and what the cause was of the corruption?

Leslie

In an open world there's no need for windows and gates

http://www.ubuntu.com

 

[firebirdta84]

Hi Leslie,

Yes, I did check out the links above, but I'm not quite sure how to tell who caused the corruption. I am able to see what users are currently in the database, but beyond that, I can't seem to figure out how to get visibility to who caused the corruption.

Thanks,
Joe

 

[firebirdta84]

Going back to this....

Every time this issue occurs, someone is entering information into a Memo field. I have two memo fields in the database. Some people use it like a note pad (i.e. hitting return to start new lines, putting a ton of info in there). Would this cause the Record is Deleted error?

Joe