Pls help with Database shutting down

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TotallyConfused - 18 Mar 2006 00:34 GMT

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.

Reply to this Message

John Vinson - 18 Mar 2006 01:28 GMT

>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
[quoted text clipped - 4 lines]
>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]

Reply to this Message

TotallyConfused - 18 Mar 2006 03:02 GMT

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?

> >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
[quoted text clipped - 20 lines]
>
> John W. Vinson[MVP]

Reply to this Message

John Vinson - 18 Mar 2006 03:31 GMT

>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]

Reply to this Message

TotallyConfused - 18 Mar 2006 06:29 GMT

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

> >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?
[quoted text clipped - 4 lines]
>
> John W. Vinson[MVP]

Reply to this Message

Brian Bastl - 18 Mar 2006 15:32 GMT

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

Brian

> Can you please provide a link to Tony's website? Thank you very much.
>
[quoted text clipped - 6 lines]
> >
> > John W. Vinson[MVP]

Reply to this Message

TotallyConfused - 18 Mar 2006 22:14 GMT

Thank you all very much for all your help.

> http://www.granite.ab.ca/access/corruptmdbs.htm
>
[quoted text clipped - 11 lines]
> > >
> > > John W. Vinson[MVP]

Reply to this Message