accde problem

R

remmons

I am ready to implement my application. I created an accde, tested it and
asked a co-worker to test it as well. Once he opened it however, none of the
buttons on the switchboard did anything - except for the exit button (which
closes the application.) So I tried it again on my workstation, it did the
same thing. I deleted the accde, recreated it, and tried it again - same
results. It works the first time, then not again after it's been closed and
reopened. It acts almost as if the macros are disabled but the exit button
does work. I am at a loss, what am I missing? Thanks for your help!
 
J

Jeff Boyce

Any chance your coworker is seeing that little security warning ... Access
will disable all code (e.g., button-clicks) unless the application is
signed, the application is located in a trusted location, or the user clicks
the options button and enables "macros" (code) to run (in Access 2007).

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
R

remmons

No, we already changed his trust settings and, it's working the same way on
my workstation. Besides, there is one command button that does work. In
fact that just sparked a thought and I double checked... the button that
works triggers an embedded macro. The buttons that do not work are all vba
code. Any thoughts?
 
J

Jeff Boyce

Sounds like security to me...

The part that's confusing to me is how it can work once then fail. Any
other conditions/configurations?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
T

Tony Toews [MVP]

remmons said:
No, we already changed his trust settings and, it's working the same way on
my workstation. Besides, there is one command button that does work. In
fact that just sparked a thought and I double checked... the button that
works triggers an embedded macro. The buttons that do not work are all vba
code. Any thoughts?

Could be a references problem too.

Do you have any references besides the basics? Are you sure you need
them? Write down the path and name of the extra ones (or put the
following code in a module and execute the code), delete from the
references list and Compile and Save All. Keep any necessary
references and ensure they are distributed to the target system.

Sub ViewReferenceDetails()

Dim ref As Reference

For Each ref In Access.References
Debug.Print ref.Name & " - " & ref.Major & "." & ref.Minor & "
- " & ref.FullPath
Next ref

End Sub

For a very detailed page on reference problems see
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

Ctrl+G will take you into the Debug/Immediate window. Then click on
Tools on the menu bar and References.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
R

remmons

What do you mean specifically?

Jeff Boyce said:
Sounds like security to me...

The part that's confusing to me is how it can work once then fail. Any
other conditions/configurations?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
R

remmons

What are the standard references?

Tony Toews said:
Could be a references problem too.

Do you have any references besides the basics? Are you sure you need
them? Write down the path and name of the extra ones (or put the
following code in a module and execute the code), delete from the
references list and Compile and Save All. Keep any necessary
references and ensure they are distributed to the target system.

Sub ViewReferenceDetails()

Dim ref As Reference

For Each ref In Access.References
Debug.Print ref.Name & " - " & ref.Major & "." & ref.Minor & "
- " & ref.FullPath
Next ref

End Sub

For a very detailed page on reference problems see
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

Ctrl+G will take you into the Debug/Immediate window. Then click on
Tools on the menu bar and References.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
J

Jeff Boyce

I don't know enough to be specific!

I was wondering about other factors ... which version of Windows?
With/without service packs? I assume Access 2007. With/without services
packs?

Just fishing...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
T

Tony Toews [MVP]

remmons said:
What are the standard references?

I can't recall and it depends on if you are running MDB/ACCDB IIRC.
Run that code and post the results.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
R

remmons

Results as follows, thanks again for your help...

VBA - 4.0 - C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL
Access - 9.0 - C:\Program Files\Microsoft Office\Office12\MSACC.OLB
stdole - 2.0 - C:\WINDOWS\system32\stdole2.tlb
DAO - 12.0 - C:\PROGRA~1\COMMON~1\MICROS~1\OFFICE12\ACEDAO.DLL
 
T

Tony Toews [MVP]

remmons said:
Results as follows, thanks again for your help...

VBA - 4.0 - C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL
Access - 9.0 - C:\Program Files\Microsoft Office\Office12\MSACC.OLB
stdole - 2.0 - C:\WINDOWS\system32\stdole2.tlb
DAO - 12.0 - C:\PROGRA~1\COMMON~1\MICROS~1\OFFICE12\ACEDAO.DLL

Those are the standard references for ACCDB so that's very unlikely to
be the problem.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
R

remmons

AS of now I am implementing as an accdb, and just securing it as much as
possible. Does anyone have any other thoughts?
 

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

Similar Threads

ACCDE 1
Convert db to accde 2
Print Button 5
ACCDE backend? 7
Database on Citrix Server 1
Trouble Creating ACCDE file 2
MDE created in 2003 with sendobject and 2007 crashing 3
Code Not Executing in Runtime 1

Top