Continuous disruptions

[Smack]

Hey ya'll. I keep getting a "MDB needs to be repaired, or this is not a database" error messages. I don't know if it is from a bad network connection on someone's pc, or if construction crews remodeling one of our buildings is causin g an interuption - or something I'm just not aware of.
Any Ideas?

 

[ReluctantDataGuy]

If repair isn't working, try creating an empty database and importing all the object from your corrupt one into it. That usually does the trick. If not, then one of your objects is bringing the corruption with it, so it may be a process of elimination.

 

[MichaelRed]

Does the app use autonumber?




MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[Smack]

Does the app use autonumber?
Several of them do.

 

[MichaelRed]

Multiuser apps cannot use auitonumber w/o some corruption - at least where new records are added by more than one user. The more generic soloution is to change the Autonumber to a different 'type'. See {F1} topic "Autonumber" for some info on this. Search these fora (Tek-Tips) for a number of discussions re the concept. See faq700-184 for an alternative soloution to retain SOME semblance of order in a promary key field.

Autonumnber -in ALL its' incarnations (types) does not lock the source of the value, so it is ALWAYS possible for two (or more) users entering data (new records) to have a 'collision' in the retrieval / incrementing of the value. When this occurs, the more common 'failuure' is a simple error message 'duplicate key value ...) which may be bypassed with a re-try (programmatically). On occassion, the error appears to not actually get traped and some record corruption occurs.




MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[Smack]

Thanks, I'll look into it.
I have had this mdb for over 2 years, and these problems just started in the last few weeks. The first time was when a fiber optic cable was cut by a construction worker. One of our buildings is going through major renovations, new offices etc so it would not suprise me if lines are accidently being disrupted.