Access 2007 Developer Extensions (DE)

R

Radiska

Problem: Weeks back, I installed DE and packaged a solution no problem. Went
into a 2003 (older database) and then the Developer menu item disapeared off
of the MS Button Menu. Before I knew to try Methods 1 and 2 below, (from MS
support page) I tried to fix by re-installing DE, then MS Access, then load
Office SP2 all to no avail. Found solutions below but the problem is, the DE
are not there to put a check mark in. Do the dll's for the DE maybe need to
be manually registered before they will show in the COM add-in Manager which
would allow me to select them?

Method 1
Enable the Access 2007 Developer Extensions COM add-in. To do this, follow
these steps:
Start Access 2007.
Click the Microsoft Office Button, and then click Access Options.
Click Add-ins.
In the Manage box, click COM Add-ins, and then click Go.
In the COM Add-Ins dialog box, select the Microsoft Office Access Developer
Extension COM Addin check box, and then click OK.
Note You must repeat these steps if you restart Access 2003 and then you
restart Access 2007.

Method 2
Start Access 2007.
Click the Microsoft Office Button, and then click Access Options.
Click Add-ins.
In the Manage box, click Disabled Items, and then click Go.
In the Disabled Items dialog box, click to select the Microsoft Office
Access Developer Extension COM Addin check box, and then click Enable.
Click Close, and then click OK
 
D

Damon Heron

Here is a solution:

Create a text file with Notepad, called backup.reg

copy this text into the file:

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\Access\Addins]

[HKEY_CURRENT_USER\Software\Microsoft\Office\Access\Addins\accessaddin.ade]
"commandlinesafe"=dword:00000000
" loadbehaviour"=dword:00000003
"description"="Microsoft Office Access Developer Extensions COM Addin"

HTH
Damon
 
D

Damon Heron

Oh, and double-click to run the .reg file - it writes the code to your
registry.

Damon

Damon Heron said:
Here is a solution:

Create a text file with Notepad, called backup.reg

copy this text into the file:

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\Access\Addins]

[HKEY_CURRENT_USER\Software\Microsoft\Office\Access\Addins\accessaddin.ade]
"commandlinesafe"=dword:00000000
" loadbehaviour"=dword:00000003
"description"="Microsoft Office Access Developer Extensions COM Addin"

HTH
Damon

Radiska said:
Problem: Weeks back, I installed DE and packaged a solution no problem.
Went
into a 2003 (older database) and then the Developer menu item disapeared
off
of the MS Button Menu. Before I knew to try Methods 1 and 2 below, (from
MS
support page) I tried to fix by re-installing DE, then MS Access, then
load
Office SP2 all to no avail. Found solutions below but the problem is,
the DE
are not there to put a check mark in. Do the dll's for the DE maybe need
to
be manually registered before they will show in the COM add-in Manager
which
would allow me to select them?

Method 1
Enable the Access 2007 Developer Extensions COM add-in. To do this,
follow
these steps:
Start Access 2007.
Click the Microsoft Office Button, and then click Access Options.
Click Add-ins.
In the Manage box, click COM Add-ins, and then click Go.
In the COM Add-Ins dialog box, select the Microsoft Office Access
Developer
Extension COM Addin check box, and then click OK.
Note You must repeat these steps if you restart Access 2003 and then you
restart Access 2007.

Method 2
Start Access 2007.
Click the Microsoft Office Button, and then click Access Options.
Click Add-ins.
In the Manage box, click Disabled Items, and then click Go.
In the Disabled Items dialog box, click to select the Microsoft Office
Access Developer Extension COM Addin check box, and then click Enable.
Click Close, and then click OK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top