Split Database Issues - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Split Database Issues

Launa Sallai

4 years ago

I followed the splitting of the database and now have the Master, Master_be and the accde file.
Everything was fine till I made a change to the Master, then saved a new accde file, pushed it out to the employees, and now the functionality is gone nothing opens on the forms, and had to roll back. What could I have missed?

	Adam Schwanz @Reply 4 years ago
Are you using the Access Updater from Ricks Template or just doing it manually by sending them the ACCDE? I wonder if they aren't downloading the update into a not trusted location

	Dan Jackson @Reply 4 years ago
Either that or it didn't output the accde file correctly. I use a file sync program myself and a few times, weird things happened and i had to repeat the process. 1. Most likely a Trusted Location Issue as Adam mentioned 2. Possible a corrupt accde file. Re-output and test to see if the issue reoccurs 3. Troubleshooter

	Launa Sallai OP @Reply 4 years ago
I do it manually. I just created a batch script to robocopy the file to everyones PC. I have a folder on the C drive called Company Database, and it gets copied there for everyone.

	Kevin Yip @Reply 4 years ago
What change did you make exactly to your "master" (which I'm assuming is your front end)? If making the change broke the front end, that could be any number of things.

	Launa Sallai OP @Reply 4 years ago
I added a Module. Seems I figured it out. When you make any changes to the VBA, you need to compile it. I did not know this. But it is working now! Thank you all for your help.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View