Access link .mdb and .accdb tables

Posted on 2012-09-03
Last Modified: 2012-09-04

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
Question by:murbro
    LVL 39

    Expert Comment

    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.
    LVL 56

    Accepted Solution

    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.

    LVL 84

    Assisted Solution

    by:Scott McDaniel (Microsoft Access MVP - EE MVE )
    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.

    Author Closing Comment

    Great answers. Thanks very much

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now