acwizlib

[Col]

Hi All... (anybody?),

I have an application written in Access 2000 to import text files calling
the import wizard using vba

ie. Application.Run "AcWZLIB.mx_Entry", 1, str_SourceFile, "tbl_TextFile",
"TEXT"

After the move to Access 2007, this stopped working with the error

Method 'GetImexTblName' of object '_WizHook' failed

I have tried opening the mdb with the /decompile switch and recompiling to
no avail.

I cant seem to find any documentation on this feature.

How is ACWZLIB different in Access 2007?

Regards

Col

 

[Peter Schultz]

aaaa

 

[Pat Hartman]

Microsoft doesn't intend for us to directly interact via code with their
wizards. That's why they are not documented. I don't know if A2007 uses
this wizard library. Are you sure you installed all the wizards when you
installed A2007. As with earlier versions, not all wizards are installed by
default.

 

[Col]

Hi Pat and thanks for the reply,

Microsoft have changed their tune a bit, one could download the source mdb
files of the 2000 wizards to help you develop applications using them. Then
later versions of your applications break with no support from MS. Great
isn't it?

All the wizards are installed in 'C:\Program Files\Microsoft
Office\Office12\ACCWIZ' folder.

Col

 

[Pat Hartman]

I think the intention was to show you the techniques they used rather than
to expose the wizard for you to interact with.

 

[Guest]

The error you are reporting indicates that the wizard is still
present (AcWZLIB.mx_Entry), but that it is not working
correctly (GetImexTblName). If you have the wizard source
code, you could look through it to see what is failing.

Possible problems might be problems with DAO/ADO
references (are you still in .MDB format?) or with the Import
Export (Imex) table, or with the contents of the Imex table.
What happens if you do an Access import first?

(david)

 

[M.L. Sco Scofield]

Col,

Pat is correct about these wizards being for learning purposes only. They
were never intended for people to hook into and use.

This is from the download package; "This special version of the wizards
contains viewable wizard code for developers to use as a learning tool. Some
wizard code remains locked to protect Microsoft proprietary algorithms. The
viewable wizards are not supported in any way by Microsoft Corporation.
Microsoft makes no guarantees about the performance of Microsoft Access when
using the viewable wizards."

You say you have the 2000 versions of the viewable wizards. I don't think
you do. The 95 and 97 versions of the wizards were made available. There
were major changes made to the wizards in 2000. For some reason, probably
licensing and/or copyright reasons, the 2000 (and later) version of the
wizards were never made available.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, A+, Access MVP 2001 - 2005
Denver Area Access Users Group Past President 2006/2007 www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
This email made with 100% recycled electrons!
Miscellaneous Access "stuff" at www.ScoBiz.com

 

[Guest]

were major changes made to the wizards in 2000. For some reason, probably

licensing and/or copyright reasons, the 2000 (and later) version of the
wizards were never made available.

I assumed that they were never made available because they had been
rewritten in C.

(david)