error 40351 on one machine but not other

**DKY** · 10-02-2008, 01:45 PM

I am running the following code

Please Login or Register  to view this content.

and this code is being accessed through a network drive by putting a shortcut in the XLSTART folder of two different machines. The problem is that I get the following error

Run-time error ‘40351’:
Application-defined or object-defined error

on one machine and not on the other. I'm trying to figure out why. The error procedes to highlight this line of code

Please Login or Register  to view this content.

Any suggestions?

**Kenneth Hobson** · 10-02-2008, 03:43 PM

Try running it in debug. Or, put a line before it to print to the Immediate window:

Please Login or Register  to view this content.

**DKY** · 10-02-2008, 03:59 PM

Okay, I'm not sure how to run in debug mode but I stepped through the program with the F8 and put that line of code in there. I hit ctrl+G to display some window called "intermediate" and it showed me the value for "Range(strletter & i)" on both my machine and the machine having troubles. The only difference is that the machine having troubles still stopped on the line that says

Please Login or Register  to view this content.

and gave me

Run-time error ‘40351’:
Application-defined or object-defined error

Whereas with mine the program runs beautifully.

Oh and P.S. that 'Solved' thing still doesn't show up and I started this topic today. LOL! Oh well.

**yawnzzzz** · 10-02-2008, 04:35 PM

I would recommend verifying what values your variables hold:

Please Login or Register  to view this content.

When you hit debug, hover your mouse over 'strletter' and 'i' to see what value they are when it errors.

Then go to the computer where it works, and mark the line directly after this line to go into debug mode. Then hover over both values again to see what they are when it works correctly.

**Kenneth Hobson** · 10-02-2008, 04:36 PM

Set Access Visible to True and insert an Exit Sub befor the loop. Did Access open? You may need to check the Task Manager.

If it opened, the user could open the file file. Using a UNC path, you may have a permissions issue.

**DKY** · 10-02-2008, 07:51 PM

Yawnzzzz
They end up having the same (correct) values on both machines.

Kenneth
For some reason I do see the database opening when I run it on both machines regardless of the Access Visible (actually I was trying to figure out how to not see the database opening and hadn't gotten that far yet). So I know that the database is opening. I was wondering if there was an issue with the 'objAccess' part of the code. I don't know what the issue could be but I just couldn't think of anything else. What kind of set up do I have that someone else doesn't. Do you think that there's possibly a permission issue on the database itself?

Other forums I've posted this question at:
http://www.mrexcel.com/forum/showthread.php?t=345011

**DKY** · 10-06-2008, 01:31 PM

The answer is always so easy, isn't it? I just figured this out. The reason it's not working on other machines is because the other machines are set up to block macros when they open Access. I set them up to allow macros and it works like a charm, thanks for the help all.

I may take some time and look into the digital signature thing but haven't quite made up my mind yet.