Results 1 to 7 of 7
  1. #1
    scoter is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Aug 2017
    Posts
    3

    can't work MS Access database

    Good day. A few days ago I created a MS Access database. Everything was working perfectly. Today tried to open it and leaves a sign that the base is corrupted and it cannot be opened. What could be the problem and how to fix it?


    Read similar threads on the forums, but a sensible solution was never found, so I had to create a new topic. Thanks in advance.

  2. #2
    Join Date
    Jun 2015
    Location
    Wales. Land of the sheep.
    Posts
    1,228
    is there an error message? or maybe a screenshot you could show us of the icon you're seeing.

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    oops. Sorry but sometimes this happens. You can try opening Access ,then run REPAIR/compact, then select your db to repair.
    It MAY fix it.
    If not, it is corrupt beyond repair. You must restore from backup.
    Ive had this happen so much that now I backup OFTEN.
    In development, I backup hourly. Production tables, daily.

    good luck.

  4. #4
    scoter is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Aug 2017
    Posts
    3
    Tried to restore from the backup of the savegames , but the result was unsuccessful (((

  5. #5
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    See if anything here helps: http://allenbrowne.com/ser-47.html

  6. #6
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    Depends on the error message you are getting. Sometimes keep tapping through and eventually it will open - might have to tap through 100 times, depends on the number of tables, forms, indexes, code modules etc. Note: use the shift key when opening to avoid any code running when the db is opened. If you have disabled this functionality, there is a possible way round it, but not worth going into if you haven't disabled it.

    Q1: Is your db split?
    A1:Yes - in which case is it the front end or backend that is corrupted?
    ..................Front End - your forms and code are lost, revert to backup
    ..................Back End - if the error is about indexes, use the export manager to export each table into a new database, you may get error messages whilst you do this, just tap through them. If that doesn't work, revert to backup
    A2: No - write out 1000 times 'I must split my database to protect my data' (do not copy and paste, that's cheating)
    ..................Go to Q1, A1, Backend - you might be able to recover your tables. Forms and code will still be lost.

    Q2: Is your db shared by multiple users - Front end if split or whole db if not?
    A1: Yes - write out 1000 times 'Each user should have their own copy of the front end' then go to Q1, A1, Backend
    A2: No - Go to Q1, A1, Backend

    Q3: Do you do regular backups?
    A1: Yes - all is not lost
    A2: No -write out 1000 times 'I must do regular backups'

    Q4: Are you working on a db on a remote server connected via a wireless network?
    A1: Yes -don't. That way lies a big increase in the risk of corruption
    A2: No - right answer

    If access is used as it is supposed to be used, the risk of corruption is minimal but can still happen. Not using it the way it is supposed to be used substantially increases the corruption risk.

    I'm with Ranman on backups. In development, I always take a backup before making any changes, make my changes, then decompile then compact and repair. And I make my changes in incremental steps - a form/functionality at a time.

  7. #7
    scoter is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Aug 2017
    Posts
    3
    Hi , thanks all for the help, I still advise to use the services of recover mdb online

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

Similar Threads

  1. Replies: 5
    Last Post: 10-06-2014, 03:00 PM
  2. Replies: 17
    Last Post: 04-24-2013, 12:58 PM
  3. Replies: 1
    Last Post: 02-04-2013, 04:00 AM
  4. Replies: 2
    Last Post: 08-15-2012, 11:42 AM
  5. Access database will not work in .Net 2003
    By Brilene in forum Access
    Replies: 0
    Last Post: 03-18-2011, 03:41 PM

Tags for this Thread

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