Database Crashed

[Guest]

For some reason, our database crashed yesterday. In one of the records, each
field had an "error" in it. I opened the table, deleted that record, closed
the table and clicked on "Compact and Repair" At that point all of my
relationships disappeared.

Firstly, does anyone know what might have happend to that one record with 20
- 25 fields?
And why would all of my relationships disappeared after a compact and repair?

Thankfully, I had a good backup from Friday so we didn't loose too much.

R Marko

 

[G. Vaught]

Is your database split? If you are scratching your head on that question,
then I know your answer is no and you should read below. If you know what I
am talking about, then skip the next two paragraphs.

If you are sharing a database with several users, the database should be
split into a front-end and a back-end. The back-end resides on a server and
only contains the tables to the database. The front-end resides on each
users machine and contains the linked tables, queries, forms, reports etc.

Access has a built-in database splitter. However, before using, back up your
database.The splitter wizard will walk you through the process. After
splitting it may be necessary to link each users copy of the front-end to
the back-end. For ease of moving the database to each users machine, have
everyone use the same mapped drive letter to the server.

If you database is split, ensure no one has compact on close checked within
their copy. If they close the database while someone else is in the
database, chances are you will get a corruption to the database. If a user
has the database open and they close down their machine without closing the
database, corruption can occur. If someone had the database open and their
was a power failure during working hours or after working hours, corruption
could occur.

I have never seen relationships disappear, so I can't help you their.

 

[Guest]

I have split other databases, so I know what you're talking about. But I
never did split this one. What are the pros and cons of splitting? I know
one con because it happens with the other database. Often, when someone
clicks on the desktop shortcut, it makes them remap the tables to the rest of
it. Any advise?