I have the autoexec macro setup to run a function.
the function is executed and runs ok when I manually execute autoexec,
watching the entire execution in the debugger.
the db is stored on a share point site. if I download a " fresh" copy and open access
the first time after the download, I get the 2001 error, see attachment.
after clicking the "stop macros" button the db finishes its open and operates normally
however, if the db is closed and reopened a 2nd
and subsequent times, it opens and there is no error 2001.
I put a quick msgbox in the function to check its execution, at startup when I don't have
the debugger available. if its the first run with the 2001 error I don't get the msgbox, I assume
that means the function was never called from the autoexec.
When opening db subsequent to first run after download, I get the msgbox.
I have checked quite a few posts and not finding a solution, any ideas here?