Error in Access 2010, something about an expression event property

Posted on 2014-08-21
Last Modified: 2014-08-27
I keep getting this error and it is frustrating me to no end.  Basically, I have had a coder building me an access database (BCT.accdb).  The first time he sent one I had to add my downloads folder as a trusted location before I could open it, no problem.  The second time he updated it (BCT_v2.accdb), it would not open, giving the below error.  I moved it to the desktop, added as trusted, then it opened.  3rd update, same thing, moved to desktop, still wouldn't open, moved to C: drive root, trusted, opened OK.  4th update, same thing, moved to desktop = no, moved to c: = no, moved to desktop\new folder\ and it worked fine. Changing the name makes no effect.  

I seem to have to put it in a new folder, trust that folder, then open the file EVERY time it is updated...  WHY!?

Error is attached.  I have discussed with my coder and even remote connected and he couldn't figure out why.
Question by:dbestcomputers
    LVL 24

    Expert Comment

    You have not attached the error
    LVL 47

    Expert Comment

    by:Dale Fye (Access MVP)
    If you have not already done so, you need to create a trusted location for this application.  Something like


    Then put your application in that folder every time you get a new version.

    Author Comment

    Ah you're right I didn't attach!

    And Dale, I have created the trusted location, my point is that every time I get a new update, I get this error and have to MOVE the file to a NEW location and then trust that new location as well.

    This is Access 2010 BTW.
    LVL 48

    Expert Comment

    by:Gustav Brock
    Use your LOCALAPPDATA folder, that should work.

    At a DOS prompt:

    c:\>cd %localappdata%

    LVL 84

    Accepted Solution

    Is your coder zipping the file before sending? If not, might try doing that, just to be sure the file is safe and such.

    Otherwise, sounds like you've got issues with YOUR installation of Windows or Access/Office, and more specifically with UAC. A Trusted Location is a Trusted Location for ALL Access databases. Be sure that you're fully up to date regarding patches/fixes. If you still have the issue, you might try a Repair of Access/Office.

    Author Closing Comment

    Correct I did have some issues.  After uninstalling Office, reloading, and updating to latest Service Pack problem appears resolved.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now