how do I connect to multiple backends access 2010?

I have a number of backends that are near the 2GB limit and would like to connect to several with the same front end.  How do I do that?
Connie Campbell-PearsonOwnerAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Interesting ... here is the same Q basically that is in progress now:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_26842588.html?cid=1573#a34966805

As I noted in that Q ...
One note about splitting into multiple db's:  IF ... you decide to do so, you *cannot* create Relationships between tables across multiple db's ... if that is important to you.

And if you are near the 2GB limit ... which is like approaching a Black Hole ... time to think about SQL Server ...


mx
0
 
Patrick MatthewsCommented:
Just as you would in linking to a single back-end: add in the tables from the back ends as linked tables.
0
 
lee555J5Commented:
Each linked table can connect to a different backend.

In your front end, go to External Data and click Access in the Import & Link section. Specify the db and the table.

Lee
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
<time to think about SQL Server >

Agreed, and SQL Server Express is free, and the 2008 version supports up to 10 gb per database:

http://www.microsoft.com/express/Database/

If you do this route, you might consider using the SQL Server Migration Assistant:

http://www.microsoft.com/sqlserver/en/us/product-info/migration-tool.aspx#Access

While Access includes the Upsizing Wizard, the SSMA tends to do a more thorough job.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.