Announcement

Collapse
No announcement yet.

How connect a MS Access db that is located on a network server

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How connect a MS Access db that is located on a network server

    Hello all,
    I need to connect to a MS Access DB that is on a server directory of a company network i.e. \\server02\DINAMICO\DATI\EOSSRL\datixp.mdb
    I made the new ODBC (both 64 and 32 versions) and in theory it work by itself.
    I installed also AccessDatabaseEngine_2010_x64.exe as suggested on connection form.
    Then I created a new connection into SC using first Generic ODBC , giving the name of ODBC created but SC gives me back this error when I click on test connection button

    Connection Error

    odbc_connect(): SQL error: [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides., SQL state S1009 in SQLConnect

    The ODBC is correct because if I try to use double or single quote around "\\server02\DINAMICO\DATI\EOSSRL" it doesn't work already on ODBC saving.


    Then again I tried to use Ms Access specific connection type but the same error arises.

    Is there a fix or workaround ? For me it's unbelievable ... but everyday there is a new issue ...
    Thanks

    Attached Files
Working...
X