This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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?
A family of Microsoft relational database management systems designed for ease of use.
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.
I figured it out. The changes were I added a module and did not compile it. Once I compiled it, and then made the accde file it worked. It was the first time doing this, so I had no idea. It seems any time you make changes in VBA, you need to compile it.
Thank you everyone for all your help!
I'm assuming that you made the table design change in the backend, then relinked the front end to that table with File... Get External Data... Link, and then edited the VBA in the frontend? As Scottgen asks, do you have any startup code or a startup form designated? If the Forms pane is available on the nav pane, can you open any forms from it?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
First you tell someone who ALREADY has a split database how to split it. then you post 2 non working links.
Hello
Please refer the below mentioned articles.
https://support.microsoft.com/office/2eb616b-3204-4121-9277-70649e33be4f
https://support.microsoft.com/en-us/office/a3b1f0fa9-e988-40e0-8f5f-40fe9c1f7126
Regards,
Md Abdal
The tables are there and point to the correct location. Its the forms do not open.