• WendellB (8/30/2013)


    This is actually a linked table with a Microsoft Access front-end using ODBC, and in typical ODBC fashion, it gives an obscure error code that indicates the user does not have the permissions necessary to insert a record in that table. I didn't actually record the error number - sorry, and I should have also recorded the actual error message text, and I didn't do that either. Unfortunately the system is at a remote site where it is very difficult to try to replicate the problem and get the actual message, but I will do that if the steps suggested above don't resolve the issue. Thanks.

    This changes about everything:

    check the whole line from you local account - linked Server Login mapping - up to the permissions of that mapped account.

    I would not be surprised, if there was a mapping for sysadmins only...

    Andreas

    ---------------------------------------------------
    MVP SQL Server
    Microsoft Certified Master SQL Server 2008
    Microsoft Certified Solutions Master Data Platform, SQL Server 2012
    www.insidesql.org/blogs/andreaswolter
    www.andreas-wolter.com