Results 1 to 5 of 5
  1. #1
    CQCDave is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Nov 2014
    Posts
    47

    Database keeps crashing


    I have a MS Access 2010 database that has been running with no issues since 2015. The database is split the back end of the database resides on a file server Windows 2008 server R2. Each user has their own copy of the front end on the same server with a shortcut on their desktops. Most users are running Access run time 2010, only 1 or 2 copies of the full application of access. The company recently completed an upgrade to Windows 10. However many users had been on Windows 10 with no issues. The database keeps being “Microsoft Access has detected that this database is in an inconsistent state.” I will open the back end and it will recover. I will perform a Compact and Repair on the back end and the system will work. But then it will happen again. I am looking for any help on how to find what is causing this and recommendation for any 3rd party repair tools that you may have used to assist in resolving this issue.

    Thanks for you help.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    SOME pc's don't like the db.
    i had a db that ran on every PC but 1.
    repair didnt work,
    rebuilding didnt work.
    I has to swap out laptops.
    There was just some conflict that would not work together.

    did you try ,on that bad PC,
    create a blank Db, import all objects from the problem db?

  3. #3
    CQCDave is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Nov 2014
    Posts
    47
    We thought it was one PC, we wiped the pc and did a fresh install. While that one was off line it happened again on a different machine that had been using the database for moths after being upgraded to Windows 10.

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,979
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  5. #5
    CQCDave is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Nov 2014
    Posts
    47
    Thanks for the information, will pass it along to IT to investigate and test out.

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

Similar Threads

  1. Database crashing
    By baderms in forum Programming
    Replies: 2
    Last Post: 04-12-2018, 08:03 AM
  2. DB Keeps Crashing
    By onechriswhite in forum Access
    Replies: 4
    Last Post: 07-04-2014, 04:19 PM
  3. Replies: 14
    Last Post: 08-19-2013, 09:37 AM
  4. Search Query crashing database
    By Hamm in forum Forms
    Replies: 5
    Last Post: 01-10-2013, 12:29 PM
  5. Access Crashing - Need help please!
    By rave41799 in forum Programming
    Replies: 3
    Last Post: 09-10-2011, 03:28 PM

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