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

No vba code in Access 2007 accde will run

I am running access 2007 on win vista PC.  I have converted database from accdb to accde and when I run the accde , none of the buttons on the opening form (or any other form) do anything.  I have added the folder to trusted locations and compiled the database.  I have tried creating a new blank database and importing all the forms and tables and modules.
0
mdlines
Asked:
mdlines
  • 3
  • 2
  • 2
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:

 Why did you add this to the Sharepoint Zone?  I can move it for you if it's un-related to Sharepoint.

 Does your app compile without errors?

Jim.
0
 
mdlinesAuthor Commented:
hi- sorry about the sharepoint - yes please move it to access.  the app compiles fine.
Martin
0
 
danishaniCommented:
Did you Compile your VBA code before creating the ACCDE?

Goto Debug > Compile in VBE window.

Hope this helps,
Daniel
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:

  Does the accde run fine on another machine?  WHat you have happening is fairly odd given what you've already said.

Jim.
0
 
mdlinesAuthor Commented:
yes I compiled it and it was fine
0
 
mdlinesAuthor Commented:
On  another PC I get the untrusted location dialogue but I assume IF IT does not run on the same pc that it was developed on then there is no chance of it running on anything else.
0
 
danishaniCommented:
When you open your ACCDB, you dont see any Security message popup in top of your Screen?
Like below:
 sec warning
Usely when you have created an ACCDE, and there is no VBA code, it means most of the times you have not Compiled the code.
Another thing you might check if there are missing references.

Hope this helps,
Daniel
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

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