Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1209
  • Last Modified:

Why do I get the following message when I click on Switchboard Manger; >Method AccessUser DataDir of object Wizhook failed<?

I've created a database using Access 2007.  Every time I've wanted to make modifications to the default switchboard I've just clicked on Switchboard Manger-- the wizard is activated and I've have had no problems making the modifications.  Yesterday I clicked on Switchboard Manager to make a modification and the following message appears and the wizard will not activate, >> Method 'AccessUserDataDir' of object'_WizHook' failed<<.   I have searched all over for the enabling and disabling option but to no avail.
How do I get the Switchboard Manager reactivated?

Thanks in advance
0
rhlopez1
Asked:
rhlopez1
  • 3
  • 2
  • 2
  • +1
2 Solutions
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Yikes!!

First, try Compacting and Repairing the database.

mx
0
 
dannywarehamCommented:
The only worthy resource I can find on Wizhook is here
http://www.pacificdb.com.au/Support/CodeFiles/Access_WizHook.pdf

Are you using the functions it provides without setting your "key"?
0
 
rhlopez1Author Commented:
Thanks for the response, I read the reference last week and at first paid little attention to it because of the last update date on it.  Today I read it again and tried to understand it, but I'm afraid it wasn't much help- probably because of my beginner level.  After reading the reference I accessed the following Access files (databases) in search of the wizhook file.  Listed are the files I searched:
ACWZDAT12.ACCDU
ACWZLIB.ACCDE
ACWZMAIN.ACCDE
ACWZTOOL.ACCDE
ACWZUSR.ACCDU
I could not find any table, query, form, or report that asks for a wizhook key.  I must say that I search all over but I did not search "every" object.  If the location to input the key is in one of the objects in one of the above files can you help by directing me to it?  If the location to insert the key is in a code... then I need even more help.  Which object, which in the code?

Thanks for you help in advance.
 
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Jeffrey CoachmanMIS LiasonCommented:
rhlopez1,

LOL,

Keep it simple buddy, Create your own Switchboard.

Just create a from and drop buttons on it.
Use the button Wizard to tell the buttons what to do.

The switchboard is a combination of a Form, VBA Code and a Table.
If any one of them gets out of sync with the others, all hell can break loose.
All it takes is changing one value in the table, or modifying one code statement, of changing one form property!
Oy!

Once, every year I get pumped up, and I will decide I will "Tame" the switchboard manager
Every year I fail.
:-(
LOL

The SWM is even more complex in 2007.

JeffCoachman
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Just Say NO to the Switchboard ...

Instead, easily create your own professional looking Custom menus - with NO code.

Everything you need is here ... see this link:

http://www.jamiessoftware.tk/articles/menubars.html
       
Not sure it that article mentions it, but ... when you are in the Customize mode (dialog) ... if you hold down the Control key, you can drop and drag (ie, copy) menu items from one place to another ... handy for making a new menu that is similar another one.

Here is a related link also:

http://office.microsoft.com/training/Training.aspx?AssetID=RP010036621033&CTT=6&Origin=RC010036361033

http://msdn2.microsoft.com/en-us/library/aa210698(office.11).aspx

mx
0
 
rhlopez1Author Commented:
Thanks for all the advice.  Since my last post this is what has transpired (or not transpired).... Came in yesterday morning and clicked on the switchboard manager, and "bingo", it works.  Didn't change, add, delete anything?  The wizard, I guess, just decided to take a week off!!  This is the kind of thing that I think burns everyone... something goes wrong and it fixes itself?  Because of what happened I am guessing that the problem may occur when the server or database is in a certain state, sort of how the database prevents a user from logging on if another user has a form or report in design mode???

Based on your advice and comments I'm guessing there is still no answer on how to fix the wizhook error?  I will definitely consider building my own switchboard manager if the problem continues to happen and will certainly get smarter on creating menus.  

Thanks
0
 
Jeffrey CoachmanMIS LiasonCommented:
rhlopez1,

Well, if the problem is gone and you did not figure out why, and fix it, it will probably return again.

Again, the switchboard manager code is new in Access 2007, so there is not that much info out there on it.

Why not just create your own menu now?
Why wait?

I will take about 30 mins. tops, and you NEVER have to worry about this issue ever again.
;-)

JeffCoachman
0
 
rhlopez1Author Commented:
You're right, it will return... that much I do know.  I so plan to develop my own menus as soon as I have time. I know it does not take long but I have some reading to do before I attempt it.

Again, Thanks for your advice and comments.
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

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