Q- After I've split my database, if the fornt and backend are on different computers how do I deliver changes for forms, reports and tables especially if the (Front End) can be on several different computers?

---

Reply from Richard Rost:

Well, you CAN keep a working copy of the Front End database on the SERVER for people to use. If your database isn't that big (a few MB perhaps) and your network is fast, it's OK to just have multiple clients running that file directly.

However, if you have the Front End distributed to lots of different workstations, then it's really up to you to distribute those changes. You can make it as simple as creating shortcuts to their database folders and they copying and pasting the new FE file yourself. Or you can email them a link and say "here, download this." I even went so far with one client to program an automated solution that would:

1. Check for a new version (number stored in a table)
2. If it was new, quit the database and launch a BATch file
3. Batch file copies new ACCDB file from server to local workstation
4. Batch file then re-launches database

It's completely up to you.

Richard

P.S. If enough people want to see how I created that automated solution, let me know. If I get a handful of people interested, I'll make a mini seminar out of it.