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. DBG 11,381 Reputation points Volunteer Moderator
    2024-12-05T13:41:17+00:00

    Do you see them when you open the file in dev mode? Can you post some screenshots?

    0 comments
  2. George Hepworth 21,805 Reputation points Volunteer Moderator
    2024-12-05T13:48:18+00:00

    What does it mean to say the forms do not appear?

    Are you talking about seeing them in the Navigation Pane?

    Or, are you saying you can't open them in Form View to work with them?

    0 comments
  3. Anonymous
    2024-12-05T14:09:06+00:00

    Hi LuGenMG,

    To resolve the issue of forms disappearing after splitting your Microsoft Access database, try these steps:

    1. Check Form Visibility: Right-click on the form in the Navigation Pane and select Properties. In the General tab, check if the Visible property is set to Yes.
    2. Repair the Database: If the forms are present but not showing, try the 'Compact and Repair Database' utility in Access. This can often fix issues with the database structure.
    0 comments
  4. Anonymous
    2024-12-05T14:17:26+00:00

    In the navigation pane certain forms don't appear in the list, is what I meant. Sorry for the unclear language. Not ALL the forms are missing, just some. Also in untouched backup files.

    0 comments