Home Forums SQL Server 2008 SQL Server 2008 - General Create link server for Microsoft Access2000 RE: Create link server for Microsoft Access2000

  • December 12, 2013 at 12:00 pm

    #1673061

    pietlinden (8/28/2013)

    Wouldn't you use JET4.0 instead of ACE? ACE is the filetype for Access 2007 and beyond.

    the ACE drivers are required for a SQL server 64 bit version to connect; they are backwards compatible for "earlier" versions of access; it's also possilbe to install the 32 bit verison of those drivers, when you need the 64 bit verisons installed instead.

    my first question, is if you move a copy of the access database to be LOCAL on the SQL server, does it work?

    my first guess would be the local account running SQL server does not have permissions to the share:

    \\us-balt-san-1\inhouse$\shipping\FX\DATA\fx.mdb';

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!