Access link .mdb and .accdb tables


A software partner of ours has several Access 2003 .mdb databases at various sites that need to link to a table in my Access 2007 .accdb database accross each respective network.
What is the fastest/easiest way to set this up
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Short answer?  Don't.  

 JET will no oeprate over a WAN unless it is very high end.  If your running a VPN across the internet, it's not going to fly and you'll get database corruption at some point.

Can you give more detail? Are all networks connected? If yes, have you any problems with channels quality? How big are databases?
From my experience will be better to make local copy of remote files with reasonable interval with some file sync software and link local files.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can't link tables from an .accdb formatted database to a .mdb formatted database.

See the section on Linked Tables, at the bottom of that article.
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Great answers. Thanks very much
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.