Unable to view Objects (1 Viewer)

Robert_C · Dec 9, 2019

:banghead: :banghead: :banghead: :banghead:

I've been banging my head against the wall for a while, now.

Short version - I am unable to view any of the objects in this back end database. Microsoft Access 2013.

Yes, i have gone into Navigation Options and ensured that Show Hidden Objects is checked, along with Show System Objects and Show Search Bar.

I have also tried the older trick of "holding down the shift key"...

What's strange is that when I build a query, all of the tables are displayed that are in the Database. Still, none of them can be seen in the Navigation Pane.

I can also create new tables. I can design and import data and save them. But then I can't open them, again, unless I link them to another database to view.

Any thoughts as to how to proceed?

Is the database just super corrupted and I need to attempt to rebuild it?

Any insight would be GREATLY appreciated!

~Robert

Pat Hartman · Dec 10, 2019

Try using the custom view so you can see what is in the custom groups. This is a technique that makes it more difficult for nosy people to get to tables in the BE but it is not foolproof. You should be able to undo it if you poke around enough. I would work on a copy of the BE though to avoid doing any damage.

June7 · Dec 10, 2019

Frontend and Backend both Access? Try a new frontend - same issue?

Robert_C · Dec 10, 2019

June7 said:
Frontend and Backend both Access? Try a new frontend - same issue?

Yes. Both Front and Back are done in Access.

This was inherited from someone who has since moved on... so I'm trying to pick up the pieces.

June7 · Dec 10, 2019

I assume the frontend is an accdb file because you are able to do design edits. I've never seen this issue and cannot replicate. If you want to provide files for analysis, follow instructions at bottom of my post.

isladogs · Dec 10, 2019

Please run this query in the FE and post a screenshot of the results

Code:

SELECT MSysObjects.Name, MSysObjects.Flags, MSysObjects.Type
FROM MSysObjects
WHERE (((MSysObjects.Type)=1 Or (MSysObjects.Type)=4 Or (MSysObjects.Type)=6));

Robert_C · Dec 10, 2019

isladogs said:
Please run this query in the FE and post a screenshot of the results

Code:

SELECT MSysObjects.Name, MSysObjects.Flags, MSysObjects.Type FROM MSysObjects WHERE (((MSysObjects.Type)=1 Or (MSysObjects.Type)=4 Or (MSysObjects.Type)=6));

Attacched below.

isladogs · Dec 10, 2019

Thanks for confirming the linked and local tables exist.
Can you see the linked tables in the linked table manager?

Suggest you now try my other suggestions to deal with probable corruption

Robert_C · Dec 10, 2019

isladogs said:
Thanks for confirming the linked and local tables exist.
Can you see the linked tables in the linked table manager?

Suggest you now try my other suggestions to deal with probable corruption

The Linked Table Manager is greyed out.

Also, since I'm new to this forum, I haven't posted enough to see any links or info in your bio.

But, it sounds like i need to just recreate the entire database...?

In this case... I would normally just copy all of the tables from one database into the next... but once I link them to another DB, will I be able to tell which tables are linked from other places, vs what are just static info?

isladogs · Dec 10, 2019

Apologies. I was thinking of another thread with similar issues where I'd outlined a strategy

1. Try decompiling a copy of your database to remove any corrupt compile code.
See http://www.fmsinc.com/microsoftaccess/Performance/Decompile.asp

2. If that fails import all objects into a new blank database. Linked tables should be 'imported' as linked tables. However that may fail in your case due to whatever has caused this. If so just link them from the BE.

If all of that fails van you upload both FE and BE for someone to look at?

Unable to view Objects (1 Viewer)

Robert_C

New member

Attachments

Pat Hartman

Super Moderator

June7

AWF VIP

Robert_C

New member

June7

AWF VIP

isladogs

MVP / VIP

Robert_C

New member

Attachments

isladogs

MVP / VIP

Robert_C

New member

isladogs

MVP / VIP

Similar threads

Users who are viewing this thread