Post reply

Macro stops working from other workstation

  • May 1, 2008 at 12:18 pm

    #75198

    I have an access 2007 database (running in 2003 compatibility mode) that is doing appends to a SQL Server table which runs fine from my workstation. The append is happening via a macro that calls a query. The MDB is running from a network location so when we try to run from another workstation it does the insert in to the SQL table but then the macro errors with a 2950 error and stops executing. It is actually inserting the records correctly into the SQL table. Next part of the macro which is stopping is running a pass thriough query. Please advise.

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

  • May 2, 2008 at 9:17 am

    #810153

    Is it a simple case of SQL Server Execute permissions? Are you using Windows security on your SQL server and logging in on the other workstation with different credentials? :crazy:


    Ade

    A Freudian Slip is when you say one thing and mean your mother.
    For detail-enriched answers, ask detail-enriched questions...[/url]

  • May 2, 2008 at 10:11 am

    #810209

    I found the issue. It was the connection string was not set correctly in the pass thru query. It was set to different ODBC name on the other workstations.

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

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

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