Add a table to a back end database.

Question

I have just split our surgery database for 3 users to access on our network server.  How do I add a new table to the back end database that connected to the individual front end databases?  Also, what happened to all the relationships.  The realtionships window is now empty in both the back and front end databases.

Answer 1

1. Open the back end database in design view, and add the new table. Save. Close
2. Open a front end, and link the new table.
3. Repeat step 2 for your other front ends, or replace them with a copy of the updated front end.

You should be able to see the relationships in the back end database. Open the Relationships window, and click the Show All Relationships button.

That should work in the front end also.

---

Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to forum, rather than allenbrowne at mvps dot org.

Answer 2

Although typically not a recommended approach (updating back-end structure from the front-end), it can be done.  You could inspire yourself with Allen's code from his site http://allenbrowne.com/func-dao.html#CreateTableDAO and instead of setting db = currentdb(), you could use it to open an instance of your back-end to work with/edit.  You have to ensure the BE isn't being used by any other process when you do this.

Answer 3

So how is this done in VBA?

1. the user has no chance to do so - mine are running ACCESS RUNTIME <sic>.
2. How?

3 - doesn't apply

Dave