Share via

Split Access Database

Anonymous
2022-10-14T16:32:40+00:00

I previously split my access database. Everything went fine. And today I made some changes to the master and saved a new accde file and distributed it. No the new accde file doesn't function properly. Nothing will open. I rolled back to the old accde file. Now I don't know what to do. What could I have done wrong?

Microsoft 365 and Office | Access | For home | Windows

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

11 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ScottGem 68,830 Reputation points Volunteer Moderator
    2022-10-15T00:22:55+00:00

    Do you open the Nav Pane? Can you open the forms from it?

    If you don't open the Nav Pane, go back the the accdb and see if you have a default form set under Options. Of do you have an Autoexec macro to open the forms?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2022-10-14T22:50:03+00:00

    I made one design table change and also added a Module in VBA. When you open it, everything is there, but none of the forms open.

    Was this answer helpful?

    0 comments
  3. ScottGem 68,830 Reputation points Volunteer Moderator
    2022-10-14T20:01:35+00:00

    Can you be more specific about what "doesn't function properly. Nothing will open" means? Any error messages? Did you test your changes while still an accdb? As John asked did you relink to the production back end?

    Note: a normal procedure would be to open the development copy, relink to the development back end, make and test your changes, relink to the production back end, then create a new production front end.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2022-10-14T19:16:28+00:00

    What changes did you make to the frontend? Most importantly, did you relink the modified frontend to the tables in the backend? If you hover the mouse cursor over the names of the tables in the frontend, do you see the path and name of the backend?

    Was this answer helpful?

    0 comments
  5. Anonymous
    2022-10-14T18:23:32+00:00

    Hello Launacs ,

    I am Md Abdal and I would be glad to help you with your question.

    When you split a database, you reorganize it into two files — a back-end database that contains the data tables, and a front-end database that contains all the other database objects such as queries, forms, and reports. Each user interacts with the data by using a local copy of the front-end database.

    To split a database, you use the Database Splitter Wizard. After you split the database, you must distribute the front-end database to your users.

    For more information please refer the below mentioned article.

    https://support.microsoft.com/office/3015ad18-a3a1-4e9c-a7f3-51b1d73498cc

    I hope this information helps.

    Give back to the Community. Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below

    Kind Regards,

    Md Abdal

    Was this answer helpful?

    0 comments