Hello, I have come across an odd issue that I cannot figure out how to fix. Hoping someone here can help me out.
I got a request earlier to add a couple of fields to an export query in one of our access databases. Easy request, figured it'd take a couple minutes tops. Most of our programs are generally in use by someone on the network, so what I normally do is make a local copy of the database, make my changes, then once there are no users in the database I'm using, I copy my updated copy back to the server. I've been doing this for years and it has never presented an issue. Today though, I think some sort of reference information somewhere got corrupted.
Every method (and I do mean EVERY method, On Click, On Load, etc.) on the form in this database throws the following error: The expression On Load you entered as the event property setting produced the following error: Variable not defined. (Note that "On Load" is replaced by the relevant event / method name)
I tried opening the server copy directly and got the same thing. No other databases on the server are having this problem. The server copy of the database also opens fine on any other computer I've tried it on, so it's not the file, but something with my specific computer. Here are the things I've tried to fix the issue:
Pulled a copy from our backup system
Renamed the local copy
Renamed the server copy
Compact/repair
Remove and reinstate the VBA reference "Microsoft DAO 3.6 Object Library"
Compared VBA references to a computer where the server copy still worked fine (they matched)
Deleted a finicky calendar control off of the form that had been problematic in the past
I've pulled this database off the server before and edited it locally in the past as well. I suspect that somehow, Access is looking at some sort of locally stored reference information about the forms in the old version and trying to load them in relation to this newer version and since they don't match, it's breaking. I could be totally off base, though.
Anyone have any other ideas for me to try? I'm at a loss here.
Thanks in advance for any input!
Brooks Tilson
Database Development
Tilson Machine, Inc.
I got a request earlier to add a couple of fields to an export query in one of our access databases. Easy request, figured it'd take a couple minutes tops. Most of our programs are generally in use by someone on the network, so what I normally do is make a local copy of the database, make my changes, then once there are no users in the database I'm using, I copy my updated copy back to the server. I've been doing this for years and it has never presented an issue. Today though, I think some sort of reference information somewhere got corrupted.
Every method (and I do mean EVERY method, On Click, On Load, etc.) on the form in this database throws the following error: The expression On Load you entered as the event property setting produced the following error: Variable not defined. (Note that "On Load" is replaced by the relevant event / method name)
I tried opening the server copy directly and got the same thing. No other databases on the server are having this problem. The server copy of the database also opens fine on any other computer I've tried it on, so it's not the file, but something with my specific computer. Here are the things I've tried to fix the issue:
Pulled a copy from our backup system
Renamed the local copy
Renamed the server copy
Compact/repair
Remove and reinstate the VBA reference "Microsoft DAO 3.6 Object Library"
Compared VBA references to a computer where the server copy still worked fine (they matched)
Deleted a finicky calendar control off of the form that had been problematic in the past
I've pulled this database off the server before and edited it locally in the past as well. I suspect that somehow, Access is looking at some sort of locally stored reference information about the forms in the old version and trying to load them in relation to this newer version and since they don't match, it's breaking. I could be totally off base, though.
Anyone have any other ideas for me to try? I'm at a loss here.
Thanks in advance for any input!
Brooks Tilson
Database Development
Tilson Machine, Inc.
