Macro stops working on other workstation

A

alorenzini

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. Next part of the macro which is stoping is running a pass
trhough query. Please advise.
--
Thanks,
Art
Database Analyst
Tastefully Simple, Inc.
(e-mail address removed)
320.763.0695 ext. 1807
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC - call failed during runing of macro 1
Mouse scroll-wheel stops working after run macro 0
Calling Access 'form' from other applications 0
Macro error 2950 after pushing to SharePoint 0
Running a Macro 5
Cancel Macro If Table is empty. 5
Program stops (creating pivot table) when too many records 1
Excel 97 Mouse scroll-wheel stops working after run macro- edited 0

Top