• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 772
  • Last Modified:

Buttons fail on ACCDE

Windows 7 32, Access 2007

I have an Access 2007 ACCDB that works fine.  The Trust Center settings in Access cover both the folder where the backend is (server) and where the front end is (local PC).  I create an ACCDE since I don't want users putzing with the application. Right now it is in the same folder as the ACCDB.

None of the buttons on the switchboard form work when I run the ACCDE.  Tabs work. Just the buttons fail.  I get no messages.  The button 'depresses' to show it was clicked but no new form opens.    

I have just discovered something.  If I open the ACCDE with the shift key held and I then do Alt-F11 to get into VBA there is no code available.

What am I missing?
0
IBMJunkman
Asked:
IBMJunkman
  • 4
  • 3
1 Solution
 
Dale FyeCommented:
The reason the code is not available is because it is an ACCDE

Cannot say that I've run into a similar problem where code in an accde installed in a folder which is a trusted location will not run.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Is this an issue just with the switchboard buttons...?

...In other words, ...Will buttons on other forms work?

Before you created the accde file, did you compile your code and compact/repair the DB...?
0
 
IBMJunkmanAuthor Commented:
How to I compile the code?  I thought creating the ACCDE did that?

I opened a couple of other forms and their buttons don't work either.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
IBMJunkmanAuthor Commented:
I just tried the ACCDE on Windows 7 64 Access 2010.  Still does not work.

Then I created the ACCDE with Access 2010.  Still does not work in Access 2010.  And understandably Access 2007 complains about the DB format.
0
 
Jeffrey CoachmanMIS LiasonCommented:
<How to I compile the code?  I thought creating the ACCDE did that?>
Yeah, but why wait until you create the Accde file to find out if there are any errors?
;-)

In the VBE click : Debug-->Compile...

<Then I created the ACCDE with Access 2010.  Still does not work in Access 2010.  And understandably Access 2007 complains about the DB format.>
Let's be clear...
What "Format" is the DB in...

I thought you stated that this was an Access 2007 format DB...?
If so then you should create the accde file in Access 2007.
...just to see if it works...

In other words, *Before* you ever opened the DB in Access 2010, ...could you create an accde file form this accdb in Access 2007?


You also did not state if (or when) you were running the C&R utility...

Here is the sequence I would use, just to be sure...

Access 2003 running an Access 2003 format DB (.mdb):
Compile code-->Compact repair-->Create MDE file
Does MDE file work?
If, No, then stop and fix.
If yes, then continue....
Create new blank Access 2007 format DB (.accdb) in Access 2007
Import all objects from the mdb file into the new accdb file
Compact and Repair-->Compile code--> Compact and repair again-->Create accde file
Does accde file work?
If, No, then stop and fix.
If yes, then continue....
Create new blank Access 2010 format DB in Access 2010
Import all objects from the access 2007 format DB into the new Access 2010 format file
Compact and Repair-->Compile code--> Compact and repair again-->Create accde file
Does accde file work?
0
 
IBMJunkmanAuthor Commented:
In Access 2007 I just compiled the VB code.  Exited Access.  Opened the ACCDB and created the ACCDE. Closed Access and opened the ACCDE.  Now the buttons work.

I don't want a 2010 version.  The users have 2007.  The version I made my changes to was already 2007.  I was just playing around with 2010 trying to see what was wrong.
0
 
IBMJunkmanAuthor Commented:
Compiling the VB code seemed to fix the problem.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Just note that "Playing" around with a 2007 format db in Access 2010 (and saving the changes) will sometimes cause the Access 2007 users to get the "Unrecognized format" error when trying to open the db, so be careful not to do anything "2010 specific" (navigation forms, ...et al)
see here for more info:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/thread/99e2eedf-0a36-4d38-9713-f3c82018c804
0
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.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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