Link to home
Start Free TrialLog in
Avatar of rhlopez1
rhlopez1

asked on

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
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Yikes!!

First, try Compacting and Repairing the database.

mx
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"?
Avatar of rhlopez1
rhlopez1

ASKER

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.
 
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
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
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.