Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Microsoft Access 2007 - Form buttons stopped working

Posted on 2012-03-28
10
Medium Priority
?
1,006 Views
Last Modified: 2012-04-04
Hi Folks!

We have a clients that has a Microsoft Access Database.  It was originally written in Office 2000 but has subsequently been run in 2003 and now 2007.  All was working okay until this morning when the form buttons have stopped working, they say they have not changed anything.  

I have checked:

File location in trusted
Macros enables
Service pack 1 installed

The data and code seems to be in place okay but the buttons just refuse to function.  They are not greyed out.

Any help or pointers would be appreciated.

Thanks.
0
Comment
Question by:KTBerwick
[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
  • 4
  • 3
  • 2
  • +1
10 Comments
 
LVL 61

Assisted Solution

by:mbizup
mbizup earned 2000 total points
ID: 37776749
Have you tried different copies of this database/ different computers/ different users /etc?

Is your database a split front end/back-end setup (this is "best practice")?  If so, have you tried a new copy of the front-end?
0
 
LVL 61

Expert Comment

by:mbizup
ID: 37776782
Btw, was "Service Pack 1" a typo?

You should check for SP2:
http://www.microsoft.com/download/en/details.aspx?id=5
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37776943
Troubleshooting basics:
All machines?
All databases?
Al Users?
...etc

Just form buttons are not working?
What about other code...?

So no button work on any of your forms, ...or just one button on one form?... or just all buttons on one form?

If users are allowed to go into design view, they may have renamed a button(s).

But again, without more info or a sample db, we are all guessing...

JeffCoachman
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:KTBerwick
ID: 37777136
Service pack 2 installed.

The setup is quite basic, 1 PC, 1 lady (no other users).

None of the buttons are working at all.
0
 
LVL 61

Assisted Solution

by:mbizup
mbizup earned 2000 total points
ID: 37777143
I would suggest trying a backup copy of the database.
0
 
LVL 61

Expert Comment

by:mbizup
ID: 37777170
Also - if you are basing your comments about the file trusted location/trust settings on what your user has reported, make doubly sure by checking this yourself.

On the surface (completely non-responsive buttons), it certainly sounds like there is no code running at all -- which sounds awfully like a macro/trust issue.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37778423
Check mbizups suggestion first...

If not, then post a generic copy of the DB here, that has this issue...
0
 
LVL 20

Expert Comment

by:clarkscott
ID: 37780394
Is it still an "mdb" or has it been converted to "accdb" (2007)?

In the code view, check your REFERENCE files.  Something may have changed.

If all else fails, create a blank mdb or accdb and import everything from the bad project into the new one.

Scott C
0
 

Accepted Solution

by:
KTBerwick earned 0 total points
ID: 37788462
Managed to get it working by making a copy of the file, clearing out the data, saving it, then replacing the data.  Still a bit of a mystery but it works!!

Thanks for all your input.
0
 

Author Closing Comment

by:KTBerwick
ID: 37805162
Still not sure of what the problem was, a bit of trial and error on my part.
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

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…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

636 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