• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 483
  • Last Modified:

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?
0
Connie Campbell-Pearson
Asked:
Connie Campbell-Pearson
3 Solutions
 
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
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
 
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now