Post reply

Insert Data into Access

  • July 23, 2014 at 1:35 pm

    #1731935

    k.. let me send u the snapshot..

  • July 23, 2014 at 1:44 pm

    #1731938

    please view the snapshots..

  • July 23, 2014 at 2:04 pm

    #1731943

    Shaun2012 (7/23/2014)

    please view the snapshots..

    you are trying to set up the linked server in SQL (via SSMS) ??

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • July 24, 2014 at 7:04 am

    #1732090

    yes..

  • July 25, 2014 at 7:12 am

    #1732355

    You need to set up an ODBC definition that points to the specific database you want to use. If you notice in the error message it says *.accdb - that is not a specific database.

  • July 25, 2014 at 7:58 am

    #1732373

    are those errors you posted occurring in SSMS when you try to set up the linked server?

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • July 25, 2014 at 8:50 am

    #1732400

    YES

Viewing 7 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy