Pls help with Database shutting down

[TotallyConfused]

Please help me with identifying why the database will close when trying to
accessing find/search in the main form. On the main form I have a list box
to lookup. There is a control box to run a find/search. There is also a
subform. The database will shut down when trying to run a find/search from
the list box or the lookup and clicking on the record selector. The form
will freeze then will shut down and makes a backup. I do not even know where
to start with this. A couple of days ago this database was working fine.
Please help as I am on a very short timeframe. Thank you.

 

[John Vinson]

Please help me with identifying why the database will close when trying to
accessing find/search in the main form. On the main form I have a list box
to lookup. There is a control box to run a find/search. There is also a
subform. The database will shut down when trying to run a find/search from
the list box or the lookup and clicking on the record selector. The form
will freeze then will shut down and makes a backup. I do not even know where
to start with this. A couple of days ago this database was working fine.
Please help as I am on a very short timeframe. Thank you.

You may have a corrupt form, or a corrupt database. MAKE A BACKUP
*now* - you may need it!

Then try Tools... Database Utilities... Compact and Repair. Does this
help?

Check out the suggestions at Tony Toews' corruption FAQ:

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

There are several possibilities - there could be a bad record in the
table that you're searching, some problem with the Form, or even a bad
DLL file in the Access installation.

John W. Vinson[MVP]

 

[TotallyConfused]

Thank you for your response. Yes I ran the repair and compact. Anything else
I can do? Do you know why or what would cause this?

 

[John Vinson]

Thank you for your response. Yes I ran the repair and compact. Anything else
I can do? Do you know why or what would cause this?

Not all corruption can be cured with Compact. See the diagnoses and
suggestions on Tony's website - that's the best advice I can suggest,
short of rebuilding the app from scratch.

John W. Vinson[MVP]

 

[TotallyConfused]

Can you please provide a link to Tony's website? Thank you very much.

 

[Brian Bastl]

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

Brian

 

[TotallyConfused]

Thank you all very much for all your help.

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

Brian