Adding tables to a split database

[CDM]

I split a database and now want to add a new table to the BE that is linked
to the FE. Could someone tell me how that is done? Thanks!

 

[DrEvil]

Go ahead and create a table on back end and then just add new linked table by
going to tables ==> New ==> Linked table ==> and then point it your back end
and then choose newly created table. Easy as a pie ;-)

Amir

 

[Chris O'C via AccessMonster.com]

Open the back end and create the new table there. Set up any relationships
you need in the relationships window. Close the db.

Open the front end db file and use the menu, File > Get External Data > Link
Tables. Browse to your db file and click on it. Click on the "Link" button.
Click on the name of your new table and click on the "ok" button.

It's now linked in the front end, so set up your queries, forms and vba code
to use it. You may have additional steps if this is a multiuser db and you
distribute an mde file to the users.

Chris
Microsoft MVP