Error in Access 2010, something about an expression event property

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.
dbestcomputersAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

chaauCommented:
You have not attached the error
0
Dale FyeCommented:
If you have not already done so, you need to create a trusted location for this application.  Something like

C;\users\youruserid\appdata\roaming\

Then put your application in that folder every time you get a new version.
0
dbestcomputersAuthor Commented:
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.
Untitled.png
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Gustav BrockCIOCommented:
Use your LOCALAPPDATA folder, that should work.

At a DOS prompt:

c:\>cd %localappdata%

/gustav
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dbestcomputersAuthor Commented:
Correct I did have some issues.  After uninstalling Office, reloading, and updating to latest Service Pack problem appears resolved.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.