Linking two access databases

M

Melinda

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

Thanks
Melinda
 
J

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.
 
M

Melinda

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top