• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 739
  • 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 CoachmanCommented:
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
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
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 CoachmanCommented:
<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 CoachmanCommented:
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

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

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