Access 2007 and ACCDE

[Scott M]

I modified my Access 2007 database (ACCDB) by adding some additional Visual
Basic code. Then from the "Database Tools" I choose "Make ACCDE". It
successfully made the ACCDE. However when I execute the ACCDE it does NOT
include my code changes. If I go back to the ACCDB the code changes are there
and work fine.

Please help! This is driving me crazy.

Scott
Orlando, FL

 

[boblarson]

You have to add the location that your ACCDE file resides as a TRUSTED
LOCATION.

See here for that:
http://accessjunkie.com/faq_33.aspx
--
Bob Larson

Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________

 

[Scott M]

I did that. In fact I moved the ACCDB to C:\temp1 and added that location to
my trusted locations and then recreated the ACCDE. It didn't work. Funny
thing is that when I run the ACCDB version it works great. When I 'compile'
the code into the ACCDE it seems to 'forget' to include any code changes.

As an FYI, I am running Win XP SP3 on a Intel Core Duo laptop with 3GB of
memory.

This really shouldn't be that complicated. The ACCDB works without a hitch
but I don't want to distribute the 'unprotected' code to my users. A simple
'Make ACCDE' should work fine but doesn't. To test, I added a simple label
and MSGBOX to the main form and made an ACCDE. The label went over fine but
the MSGBOX was dropped.

Any ideas would be appreciated.

Scott

 

[Scott M]

FYI, the application is a fe/be with all of the data in SQL Server (SQL
Server 2005 SP2). I looked at the "References" and see the following:

Visual Basic For Applications
Microsoft Access 12.0 Object Library
OLE Automation
Microsoft Office 12.0 Access database engine Object

Other than setting 'Trusted Locations" is there another sercurity setting
that would cause the VBA code to NOT be included in the ACCDE?

Thanks,
Scott

 

[boblarson]

When you say your code is not included in the ACCDE, how do you know that?
--
Bob Larson

Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________

 

[Scott M]

It works now. I was reading another post which recommended that I 'compile'
my code before making the ACCDE. From the VBA editor, I selected Debug and
Compile. Once I did that, it worked fine.

It would be helpful if Microsoft listed the steps when making an ACCDE:

Step 1: Compile the VBA code from the Visual Basic editor
Step 2: Select "Make ACCDE"

Thanks for the help,
Scott