Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

link access database tables and remote sql serverdatabase

Discussion in 'Information Technology' started by Eric Bader, Jul 28, 2006.

  1. Eric Bader

    Eric Bader
    Expand Collapse
    Guest

    I have created an access project linking to a remote sql server. I would
    like to link to my local access tables in this project as well. I can not
    connect to local access tables while I am connected to the remote sql server.


    How can I link to my local access tables in the same project? Is there a
    new version of access that allows me to do this?
     
  2. Loading...

    Similar Threads Forum Date
    Eh Janam Tumhare Lekhe... Official Movie Link... Announcements Jun 3, 2015
    Sikhism Complete Shalok Mehala 9 (Link) Videos Apr 22, 2014
    UK British PM orders probe into Thatcher link to Operation Bluestar (UPDATED) Breaking News Jan 14, 2014
    India Gwalior: A Unique Link to India's History Breaking News Nov 16, 2013
    Researchers establish link between racism and stupidity General Sep 28, 2013

  3. Sylvain Lafontaine

    Sylvain Lafontaine
    Expand Collapse
    Guest

    This would be useless because an ADP project has no local JET dbengine.
    Even if you could link to them, you could do nothing with them.

    --
    Sylvain Lafontaine, ing.
    MVP - Technologies Virtual-PC
    E-mail: http://cerbermail.com/?QugbLEWINF


    "Eric Bader" <Eric Bader@discussions.microsoft.com> wrote in message
    news:A89919CE-82B7-44A7-BB35-5BF6E4E41974@microsoft.com...
    >I have created an access project linking to a remote sql server. I would
    > like to link to my local access tables in this project as well. I can not
    > connect to local access tables while I am connected to the remote sql
    > server.
    >
    >
    > How can I link to my local access tables in the same project? Is there a
    > new version of access that allows me to do this?
     
  4. Sylvain Lafontaine

    Sylvain Lafontaine
    Expand Collapse
    Guest

    However, you could etablish a linked server on SQL-Server linked to your MDB
    file or use DAO or ADO to make some queries on a local MDB file.

    --
    Sylvain Lafontaine, ing.
    MVP - Technologies Virtual-PC
    E-mail: http://cerbermail.com/?QugbLEWINF


    "Eric Bader" <Eric Bader@discussions.microsoft.com> wrote in message
    news:A89919CE-82B7-44A7-BB35-5BF6E4E41974@microsoft.com...
    >I have created an access project linking to a remote sql server. I would
    > like to link to my local access tables in this project as well. I can not
    > connect to local access tables while I am connected to the remote sql
    > server.
    >
    >
    > How can I link to my local access tables in the same project? Is there a
    > new version of access that allows me to do this?
     
  5. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    As Sylvain states, you cannot link to and MDB file from an ADP. When using
    Access projects, I usually have a second MDB front-end to do much of the
    reporting, so that I can make use of VBA in my queries. You can connect to
    multiple different database engines using an MDB (in fact that one of the
    main reasons it was named Access).
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "Eric Bader" <Eric Bader@discussions.microsoft.com> wrote in message
    news:A89919CE-82B7-44A7-BB35-5BF6E4E41974@microsoft.com...
    >I have created an access project linking to a remote sql server. I would
    > like to link to my local access tables in this project as well. I can not
    > connect to local access tables while I am connected to the remote sql
    > server.
    >
    >
    > How can I link to my local access tables in the same project? Is there a
    > new version of access that allows me to do this?
     

Share This Page