Help !! Table disappeared completely

[GregoireLeGros]

I have a database of 7000 records. It is split into front and back end. There are 3 users. Today a table vanished completely. The filesize in Windows explorer is 1mb though a backup from a few days ago was 3mb.
Has anyone had this experience before and is there anything I can do to get the table back again. Any help much appreciated.

 

[GregoireLeGros]

Hi
I've begun to accept that I wont get the data back. I'm puzzled though as to how it happened. None of our users has the knowledge to delete a table. The database froze though while 5 people were working in it. It seems Access is not so good at multi user.

 

[boblarson]

I have a database of 7000 records. It is split into front and back end.

When you say it is split into front and back end, do you mean that each user has a copy of the frontend on their machine? If not, you need to do it that way. You should not be opening the same file on the server.
See here for more about splitting:

http://www.members.shaw.ca/AlbertKallal/Articles/split/

 

[georgedwilkinson]

Confusion here, and it does matter. You said in your OP that there were 3 users and that the DB was split. You said later that there were 5 users in it at once. The inconsistency and the nature of the problem, along with the oddity of having a table with 7K records that is 3M in size lead me to believe that you're not telling us the whole story.

1. Is the db split?
2. If yes, do each of the "5" users have their own copy of the front end on their own pc (not networked)? (That means there are 6 copies of some kind of DB running)
3. Did you check to make sure the table isn't still in the BE but just the link is broken?
4. If you cannot check #3 or don't understand it, see #1.