Forum Discussion
deborahvanm
Aug 10, 2021Copper Contributor
Old database
Hi, I have inherited an old Access database at my new job. It has been a while but I had some training on Access years ago. I need to enter data into this database but I seem to only be able to see...
deborahvanm
Aug 11, 2021Copper Contributor
Hi,
I'm not entirely sure if I have all this information but this is what I could find:
* Filename ends with .accdb (+ SQL is mentioned in file name)
* File version MS Access 2007 Database
* When I open access and check File-Account it says MS 365 Apps for enterprise (Version 2102 (Build 13801.20808 Click-to-Run)
* I have the feeling the database is locked but I'm not sure about this
* I'm able to open Design view with your Shift key solution
* Because of how it was designed I still need to go to all the separate tabs and then do the Shift key action. Is there a fast way to access all tables (preferably in Datasheet view so I can enter quickly)?
I'm not entirely sure if I have all this information but this is what I could find:
* Filename ends with .accdb (+ SQL is mentioned in file name)
* File version MS Access 2007 Database
* When I open access and check File-Account it says MS 365 Apps for enterprise (Version 2102 (Build 13801.20808 Click-to-Run)
* I have the feeling the database is locked but I'm not sure about this
* I'm able to open Design view with your Shift key solution
* Because of how it was designed I still need to go to all the separate tabs and then do the Shift key action. Is there a fast way to access all tables (preferably in Datasheet view so I can enter quickly)?
isladogs
Aug 11, 2021MVP
OK. It sounds like you have the full version as you are able to view forms in design view.
Are you able to view objects in the navigation pane?
Why do you think your database is locked?
Are you able to do some screenshots and/or upload a cut down copy of your database for someone to look at