Share via

Microsoft Access: Forms not visible since database split

Anonymous
2024-12-05T13:31:46+00:00

Hello, I oversee a database that, since our team has grown I have split, so that each user has their own front end file. The backend is only the tables, as is standard, I imagine. For some reason not all of my forms appear when I open any of the front end files. My coworker has said that they do appear for him, and since I made a backup of this database before the split, I went to check in there, and these same forms also do not appear. The problem is clearly on my end, but I don't understand how to fix it.

Any help at all is appreciated!

Microsoft 365 and Office | Access | Other | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Accepted answer
  1. George Hepworth 21,805 Reputation points Volunteer Moderator
    2024-12-05T14:19:02+00:00

    While it is true that Forms can be hidden in the Navigation Pane, the attribute setting is "Hidden", not "Visible". And that property would be the same in any copy of the accdb FE. The OP indicates a second user's copy doesn't have the same problem.

    It is possible that the OP managed to change the Hidden attribute in the original accdb before the split, then turn it on off again in the copy provided to another user, and then on again in the OP's own copy afterwards. Still that scenario needs to be fully fleshed out before we reach a conclusion.

    We don't yet know if this is actually the problem the OP is experiencing because the description doesn't clarify what it means to say "the forms do not appear".

    1 person found this answer helpful.
    0 comments

9 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-12-05T14:18:15+00:00

    Sorry for my ignorance, how do I open the file in developer mode?

    0 comments
  2. Anonymous
    2024-12-05T14:19:25+00:00

    Hello, thanks for responding. I've already tried compacting and repairing, and I can't click on the forms because the problem is they don't appear in the navigation pane. I expressed myself poorly in the original post.

    0 comments
  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  4. George Hepworth 21,805 Reputation points Volunteer Moderator
    2024-12-05T14:39:27+00:00

    Okay, thanks for clarifying.

    It is odd that they would be hidden in a copy of the accdb made before the split, and in only one of two copies of the Access FE after the split.

    So, now I'm wondering, is it only the forms that do not appear for you in the Navigation Pane? Do the tables appear in the Navigation Pane? Queries? VBA Modules?

    Is it possible that you are, in fact, looking at the Back End accdb? Only the tables would be in it, and hence only the tables would be visible.

    0 comments