Solved

Buttons won't work in Access 2013

Posted on 2013-12-09
4
2,778 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

710 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