Solved

Buttons won't work in Access 2013

Posted on 2013-12-09
4
2,312 Views
Last Modified: 2013-12-09
I have an Access db that was working correctly in Access 2010.  When I try and run it on a machine with Access 2013 the buttons will not navigate through the interface.

Using the Navigation Pane I can open tables and view data. I can run queries.  I can manually open forms and reports.  But none of my buttons respond when clicked.

I don't know of if it is related, but when I first opened in Access 2013 I had some missing references which I cleared.  I then compiled with no errors. Not sure if my problem is related to the issue I was having with the references or not.

Thanks in advance for your help.
0
Comment
Question by:Jinghui Li
  • 2
  • 2
4 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 39707243
No, what your missing is that the DB is no longer in a trusted location.

If it's not in a trusted location, then it should be asking you to enable the content when you start it.

Unless you answer yes, all marco's and code will not work.

The other option is to add its current location as a trusted location (Office button, options, trust center).

Jim.
0
 

Author Comment

by:Jinghui Li
ID: 39707247
Oddly, it is not prompting me to enable content as I was accustomed to it doing in Access 2010 - unless it's in a different place and I am missing it.  

Also, I had previously checked the box to enable our network as a trusted location but that didn't help.
0
 
LVL 57
ID: 39707260
I don't have 2013 loaded at the moment, but I'm sure that's the problem.

Look under the trust settings for message bar and see what it's set to.

By the way, is this DB in the same place as the old one or no?

Jim.
0
 

Author Comment

by:Jinghui Li
ID: 39707269
YEP!  You are right!

I had thought that checking the box to "allow trusted locations on my network" would have done the trick.  But I had to actually add our network path as a trusted location.

Thanks for putting me on the right path!  I appreciate your quick help.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
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…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

911 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

15 Experts available now in Live!

Get 1:1 Help Now