Linking two access databases

[Melinda]

Was wondering if it is possible to link two access databases and what are the
pros and cons?

Thanks
Melinda

 

[Jerry Whittle]

You can link individual tables in two different databases. On the Menu go to
File, Get External Data, Link tables.

Lots of pros. In fact splitting a database between a Front End with all the
forms, reports, queries, and code and a Back End with just the tables, is
considered very good.

About the only con is that you must be in the actual database to change
properties of a table such as adding a new column or index.

 

[Melinda]

Thanks Jerry, we are still tossing around the idea whether to not to do this.
Thanks for the input.

 

[Ron2006]

Also see following:

Generally, for a multi-user Access database application, you should
split
the database to Front-End and Back-End MDB file. The Back-End contains
only
Tables and reside on a (file) server shared directory. The Front-End
contain other Access objects and each user should have his own copy of
the
Front-End on his work-station.

See tony Toews' Web site for more info.:


http://www.granite.ab.ca/access/splitapp/index.htm


--
HTH
Van T. Dinh
MVP (Access)



Ron