database crash on my computer

[Gen]

Hi,

I have a database which is shared between different users on a shared
network drive. I wanted to make some modifications so I uploaded it onto my
computer (so it will run faster). However, I am having a problem with one
table. One of hte things I wanted to change was the main form connected to
this table. I could open it up in design veiw, make changes, but when i tried
to save changes or close the form the database crashed. So I deleted the form
and tried to make it from scratch, but now the dtabase crashes each time the
wizard tries to make a form from the table! The strange things are that the
other tables and forms seem to be fine, and this only happens on my computer.
I can make the modifications when I download the DB on another persons
computer. Has anyone had this problem before? should I reinstall Access? I'm
using 2003.

 

[Jerry Whittle]

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.

Your database is probably corrupt. A couple of quick fixes is to do a
Compact and Repair, but that usually doesn't help much with corrupt forms and
reports. Next is to open a new database file and import everything from the
corrupt database to it. Don't be surprised if the problem form won't import.

Below are some excellent resources on corruption.

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

 

[Alan]

Hi,

I have adatabasewhich is shared between different users on a shared
network drive.  I wanted to make some modifications so I uploaded it onto my
computer (so it will run faster).  However, I am having a problem with one
table.  One of hte things I wanted to change was the main form connectedto
this table. I could open it up in design veiw, make changes, but when i tried
to save changes or close the form thedatabasecrashed. So I deleted the form
and tried to make it from scratch, but now the dtabase crashes each time the
wizard tries to make a form from the table! The strange things are that the
other tables and forms seem to be fine, and this only happens on my computer.
I can make the modifications when I download the DB on another persons
computer.  Has anyone had this problem before? should I reinstallAccess?I'm
using 2003.

Hi Gen,

If you still can't recover your database using the methods above, you
may try Advanced Access Repair at http://www.datanumen.com/aar/ This
tool is rather useful in salvaging damaged Access MDB files. Hope this
helps.

Alan

 

[Tony Toews [MVP]]

On Apr 3, 10:07 pm, Gen <[email protected]> wrote:

Now this is almost two months old. Do you really think they don't
have their problem solved by now.

If you still can't recover your database using the methods above, you
may try Advanced Access Repair at http://www.datanumen.com/aar/ This
tool is rather useful in salvaging damaged Access MDB files. Hope this
helps.

You also work for that company. Posting without disclosing any
connection is highly unethical and sleazy.

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/