Windows Forum

Ask something
Discussion Locked

Macro fails to excute

0 helpful
6 replies

by singhjunk 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a strange problem, the problem seems to be with one of my access databases. I have a macro in that which will run just fine from any windows 2000 Machine in the company. However if you try to run the same macro from any NT and windows 95 machine in the company it will halt and say action failed. It will go through few quires and then stop with a message box pop up mentioning the MAcro name and telling that action failed. Has anybody any ideas how to resolve this issue.

Thanks,

6 replies

by dklippert

Are all the machines running the same version of Access? There are compatability between versions.

by shmaltz

Even if the same versions of access is running on all machines you also have to make sure that if its running some VB functions that you have a references to that function on any machine that tries to run that function. When you copy (or run a database from the network) It might not add the required references by itself.
Also try to find out what the macro is trying to do when it comes up with the error. This might help in trouble shoot the problem.

This discussion is closed to new replies.