OMG, What did I do?!?!?!?!!!

[Guest]

I have a maintenance collection data base that was working perfectly. The
data is stored on a server so everyone can access it. I had the data entry
form open and was in the middle of putting my data in the server kicked me
off. I thought no big deal. I reopened it and was going to finish adding my
data directly to the table when I noticed that all the data input into the
fields all said #ERROR. Then an error message flashed on that said, “Not A
Valid Bookmarkâ€. Every time I try to delete the record that same error
message appears. Just to make it interesting it appears for the same number
of fields that contained the data that I was trying to input. Now for the
really bad part: The table will not accept any new data, either through the
form or by direct input……HELP!!!!! ANYONE!!! PLEASE!!!!!

 

[Guest]

The database is corrupted. At times like this, nothing beats a good backup.
In fact make a complete backup of your database now and put it away for safe
keeping.

Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp

 

[Guest]

Jeff:
The first thing I'd recommend is to do a compact and repair on the back-end
database. Have you tried that?

 

[phleduc]

did you already try tools database utilities compact and repair (make a
backup first of your db)

 

[Tony Toews [MVP]]

The first thing I'd recommend is to do a compact and repair on the back-end
database. Have you tried that?

But make a copy of the MDB file first!

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Arvin Meyer [MVP]]

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

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

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com