Error when code runs in .accde / runs fine on .accdb (AC2007)

Problem solved...

I logged onto her machine myself and ran the same script from the .accde, without error. I also asked her to log onto my machine (where I have tested without problems) and she still got the same error. This suggested / validated that it was not an issue specific to the machine itself but rather the users profile.

I asked our IT guys to dump & rebuild her profile and now it works for her with no errors.

Wasn't able to pinpoint the precise issue but something was missing / corrupted in there and a new profile resolved the problem.

Hope this helps somebody and saves them from the incredibly frustrating 2 weeks of debugging required to get to this point!!

Thank you all for your kind assistance
 

Users who are viewing this thread

Back
Top Bottom