Results 1 to 9 of 9
  1. #1
    JonathanT is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2011
    Posts
    118

    Unknow DB shutdown

    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.
    Attached Thumbnails Attached Thumbnails Screenshot 2023-11-27 091923.png  
    Attached Files Attached Files

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,511
    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.

  3. #3
    davegri's Avatar
    davegri is online now Excess Access
    Windows 11 Access 2019
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,373
    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.
    Last edited by davegri; 11-27-2023 at 11:26 AM. Reason: added 3rd line

  4. #4
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,547
    Hi
    Database opens just fine for me. No Errors and Database does not close. No error messgae on open.
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

  5. #5
    davegri's Avatar
    davegri is online now Excess Access
    Windows 11 Access 2019
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,373
    Quote Originally Posted by mike60smart View Post
    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.

  6. #6
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,547
    Hi
    I can update any combobox with no issues.
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

  7. #7
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,773
    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?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  8. #8
    davegri's Avatar
    davegri is online now Excess Access
    Windows 11 Access 2019
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,373
    @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;

  9. #9
    JonathanT is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2011
    Posts
    118
    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

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Help with an unknow file
    By Yalda in forum Import/Export Data
    Replies: 2
    Last Post: 11-20-2020, 09:52 AM
  2. Detect Windows shutdown or logoff
    By jcharrow in forum Access
    Replies: 4
    Last Post: 12-04-2017, 03:50 PM
  3. unknow VBA statement
    By Lou_Reed in forum Programming
    Replies: 13
    Last Post: 07-28-2016, 10:45 AM
  4. Shutdown while Access file is open
    By evander in forum Access
    Replies: 2
    Last Post: 01-07-2016, 06:05 AM
  5. Access won't shutdown
    By farlowj in forum Access
    Replies: 3
    Last Post: 07-10-2009, 06:55 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums