Post reply

Export Access table to SQL Server using ODBC connection

  • October 21, 2009 at 7:03 am

    #227279

    The MSAccess has a docmd that allows user to export tables to SQL server if the SQL Server is defined with an ODBC connection.

    I setup the ODBC connection and made the test connection without any problem. In setting up SQl Server i set it up for mixed logins so it could accept NT Authentication or Sql server Authentication.

    I executing the docmd from access to export that specfic table, I continue to get the following error messages

    SQLState: 28000

    SQL Server Error 18456

    [Microsoft][SQL Server native Client 10.0][Sql Server]login failure for user 'my user id'

    I am the administrator on the box so I do not know why I can not push a table to the server. I know it has something to do with permissions, but I do not know what that would be.

  • October 21, 2009 at 5:43 pm

    #1069198

    Hi,

    There is usually also "State" information related to the error. Please look if this information is available, perhaps in SQL Server logs. This blog entry explains various reasons of the error you get, depending on the "State" status.

    Regards

    Piotr

    ...and your only reply is slàinte mhath

Viewing 2 posts - 1 through 1 (of 1 total)

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