Insert Data into Access

  • k.. let me send u the snapshot..

  • please view the snapshots..

  • 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

  • yes..

  • 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.

  • 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

  • YES

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

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