Results 1 to 11 of 11
  1. #1
    NickMcM is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Nov 2018
    Posts
    5

    Access database not working


    Hi Guys,
    I have developed an Access database in to a fully push button application. I had to move it from one drive to another, I moved it, it now will not open. If I double click on the file it just opens Access and goes to the 'Open Database' screen; if I open Access then try to open my file the same thing happens. I was talking to a friend, and he said that it sounds like a bit had flipped, this should not happen. I have tried compacting and repairing the file, but to no avail. I don't know what to do, apart from going back to a, rather old, backup, which I would rather not do.
    Nick

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    Have you tried to open it while holding down a <SHIFT> key?

  3. #3
    NickMcM is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Nov 2018
    Posts
    5
    Hi RuralGuy,
    Thank you for your quick response to my dilemma, but yes I have tried opening with <SHIFT> held down, it does not seem to make any difference.
    When I do try and open it with or without <SHIFT> 'enable content' flashes on the screen for, like, about .1 of a second before going to the Open Database screen as already described.
    Nick

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    Is it a split database or is everything in one db? It is not zipped up is it?

  5. #5
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    Could it be a permissions issue with the "new" location?

  6. #6
    NickMcM is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Nov 2018
    Posts
    5
    It is a split database, so the data is safe, but it had not yet gone in to production so it was just trial data anyway, it is not zipped, and I tried moving it back to the old location to see if it would open there. I did everything that I could think of. But I am now lost for ideas, other than getting a commercially available package that rescues Access files.

  7. #7
    isladogs's Avatar
    isladogs is offline Access MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,204
    Try decompiling the FE. See http://www.fmsinc.com/microsoftacces.../Decompile.asp for more information
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

  8. #8
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    Have you used the Linked Table Manager to change the location of the BackEnd? Try IMPORTING the FrontEnd into a fresh new db and see if it will open with a <SHIFT> key.

  9. #9
    NickMcM is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Nov 2018
    Posts
    5
    And I am not even sure about that...

  10. #10
    NickMcM is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Nov 2018
    Posts
    5
    Hadn't tried that yet, I'll get straight on it!

  11. #11
    isladogs's Avatar
    isladogs is offline Access MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,204
    Nick
    Hadn't tried that yet, I'll get straight on it!
    And I am not even sure about that...
    I believe you've answered both the RuralGuy and myself but I've absolutely no idea which answer refers to what!
    If you need to come back, please clarify what you are referring to!
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

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

Similar Threads

  1. Replies: 3
    Last Post: 01-11-2018, 12:04 PM
  2. Database not working in access runtime
    By deepucec9 in forum Access
    Replies: 3
    Last Post: 12-01-2015, 10:34 PM
  3. Replies: 1
    Last Post: 12-24-2014, 03:49 PM
  4. Replies: 2
    Last Post: 06-18-2013, 09:06 AM
  5. Replies: 4
    Last Post: 06-15-2011, 03: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