asked on

Access 2007 VBA call from a Macro Fails with Error 2950

We have an Access 2007 database that contains VBA code called by a Macro

We have recently moved the database to a new location and now the Macro call of the VBA code fails with Error 2950. It still works if replaced in the old location.

We have explored the suggestions within http://support.microsoft.com/kb/931407

We have set the Trusted Locations within Access to include the new location (and its sub folders)
The database opens from this location without any mention of Macros being disabled
Other macros (that just run queries) still work fine
The VBA code works fine if we trace it though one line at a time within the VBA editor.

This issue is replicated on a number of PCs and also within Windows 7 Virtual machine using Parallels on a MAC

Are there any other places we need to set trust settings?
Any other thoughts / ideas?

Thanks

Jon

ASKER CERTIFIED SOLUTION

Andy Marshall

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Badotz

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Jeffrey Coachman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

clarkscott

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jon_rs

ASKER

My sincere apologies for not closing this out promptly, and thank you for all your responses.

I suspect that one or more of the ideas you suggest will probably resolve the issue we were suffering, however we got round the problem at the time by avoiding the port completely - which partly explains why I forgot to close this one out ...

Best wishes

Jon

jon_rs

ASKER

Issue not resolved since problem avoided by alternative means, but very grateful for help offered.<br />So not able to grade solution, but points awarded to respondents. Thanks :-)