Results 1 to 8 of 8
  1. #1
    tagteam is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    501

    Database suddenly not allowing any edits

    I have a database that I have been working with for years. Suddenly it wont allow me to make any changes in the properties box. When I open up the properties everything is blank and if I try to click anything to add and event or anything it will not do anything.

    Has anyone seen this before?


    Thanks

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,570
    No.
    Go to backup?
    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

  3. #3
    davegri's Avatar
    davegri is offline Excess Access
    Windows 11 Access 2019
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,742
    Restart your computer.

  4. #4
    tagteam is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    501
    I can restart my computer but it works fine in my other databases and older versions of this database work as well. As Welshgasman said, I went to an older backup but was hoping that there was something I was missing that I could fix so I wouldn't have to redo my work. I have about half of it done but if anyone knows of a fix it would be nice to know for the future.
    Thanks

  5. #5
    CarlettoFed is offline Competent Performer
    Windows 7 64bit Access 2013 32bit
    Join Date
    Dec 2019
    Posts
    274
    You could attach the file with how it works so you can directly see what can be done.

  6. #6
    tagteam is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    501
    I cant post it, my boss wont let me. I will just have to update the old one and make sure I get a lot of backups

  7. #7
    Micron is offline Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,425
    Your db is split into front and back ends, yes? In that case all you lose is whatever you last saved as a copy.
    If you're doing a lot of design changes because it's a work in progress then you should be backing up about every hour or so.
    If your db is not split, then you have a larger issue, or one day will create a much larger issue when you lose all your data because of something like corruption.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  8. #8
    tagteam is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    501
    yes it is split and I do backups twice a week because I don't do a ton of changes to it so I was able to grab one that is not too old. I have never had that situation happen before so I was just wondering if anyone else had and if there was a fix for it.

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

Similar Threads

  1. Split Database but no edits can happen
    By DavidMcA18 in forum Access
    Replies: 7
    Last Post: 03-19-2018, 07:39 AM
  2. Database suddenly unresponsive
    By jlgray0127 in forum Programming
    Replies: 4
    Last Post: 01-25-2016, 11:19 AM
  3. Replies: 2
    Last Post: 07-14-2014, 08:59 AM
  4. Suddenly database buttons don't function.
    By Chedmeister in forum Access
    Replies: 4
    Last Post: 03-10-2012, 05:19 PM
  5. Replies: 1
    Last Post: 03-03-2011, 09:32 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