Unknow DB shutdown

[JonathanT]

I have a Database form where there are text fields that update from combo boxes on the form. Out of the blue whenever I update a field now the DB shuts down. There is no error, just a shutdown. When I reopen the DB a message displays to open in safe mode. Message and DB attached. Any help is appreciated.

[ranman256]

Sometimes i've found that 1 pc has a problem with the db that others dont.

If repair wont solve it, then (on a working pc where it wont crash) create a blank db,
then import EVERYTHING; tables,forms, code, etc.
Sometimes that solved my problem. But I did have 1 pc continually crash the db no matter what we did.
Something on that pc, a driver or version that just would not cooperate with the db.

[davegri]

Ranman's solution of importing into new DB worked for me.
That approach works many times for inexplicable problems that pop up.
You don't need safe mode.

[mike60smart]

Hi
Database opens just fine for me. No Errors and Database does not close. No error messgae on open.

[davegri]

Hi
Database opens just fine for me. No Errors and Database does not close. No error messgae on open.

Same for me, for just to open. OP states that the crash occurs when a field is updated. Same for me, if I use a combo to update a field, db is gone...
But again, Ranman's suggestion works to fix.

[mike60smart]

Hi
I can update any combobox with no issues.

[Welshgasman]

Seems to work OK for me, but why are you not filtering the combos on their respective categories?
Took me ages to find Tea amongst all the other food items.?
You do not appear to have a factor for each meal either?
I do something similar for my diabetes DB, where if I have 200g of something, then I enter a factor of 2, or if per item, then the factor represents the number of items?
Just having Lamb Chop means very little, is it a big chop or a small one?

[davegri]

@JonathanT, as WelchGasMan suggests, your data entry could be simpler. For example the rowsource for BreakBev combobox could be:

SELECT Items.ItemID, Items.Item, Items.ItemCalories FROM Items WHERE ItemCategory='Beverage' ORDER BY Items.Item;

[JonathanT]

Thanks for the suggestions. Importing my objects into a new database seems to have solved my issue. No problems with the DB during the last 2 days