[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1098
  • Last Modified:

Microsoft Access 2007 - Form buttons stopped working

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
KTBerwick
Asked:
KTBerwick
  • 4
  • 3
  • 2
  • +1
3 Solutions
 
mbizupCommented:
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
 
mbizupCommented:
Btw, was "Service Pack 1" a typo?

You should check for SP2:
http://www.microsoft.com/download/en/details.aspx?id=5
0
 
Jeffrey CoachmanMIS LiasonCommented:
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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
KTBerwickAuthor Commented:
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
 
mbizupCommented:
I would suggest trying a backup copy of the database.
0
 
mbizupCommented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
Check mbizups suggestion first...

If not, then post a generic copy of the DB here, that has this issue...
0
 
clarkscottCommented:
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
 
KTBerwickAuthor Commented:
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
 
KTBerwickAuthor Commented:
Still not sure of what the problem was, a bit of trial and error on my part.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 4
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now