Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Setup / Configuration / December 2007

Tip: Looking for answers? Try searching our database.

Unmatched query wizard will not display field lists

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sharon V - 26 Nov 2007 20:09 GMT
This is driving me crazy - my unmatched query wizard will not display
field names for any tables I choose.  All my other query wizards work
properly.  I am running Access 2003.  I have tried using both 2003 and
2000 formats.  It's not my access databases because the wizard works
correctly over the network using other people's Access software.  It is
with every Access mdb database I have tried.  I have checked every
setting imaginable but don't see anything I can do to make this work. It
is driving me crazy!  (And, yes, I do know how to do this manually, but
now I'm on  a mission to get it working!).

Thanks in advance,
Sharon

shajack2000 at yahoo.com
Jeff Boyce - 26 Nov 2007 23:17 GMT
I haven't seen what you're describing, but I have heard recently of issues
connected with using Access 2003 after applying the SP3.  Any chance your PC
has SP3 installed on your copy of Access?

Regards

Jeff Boyce
Microsoft Office/Access MVP

> This is driving me crazy - my unmatched query wizard will not display
> field names for any tables I choose.  All my other query wizards work
[quoted text clipped - 10 lines]
>
> shajack2000 at yahoo.com
Sharon V - 27 Nov 2007 01:11 GMT
I don't know, I'll have to check at work tomorrow and then post the answer.

> I haven't seen what you're describing, but I have heard recently of issues
> connected with using Access 2003 after applying the SP3.  Any chance your PC
[quoted text clipped - 19 lines]
>>
>> shajack2000 at yahoo.com
Sharon V - 27 Nov 2007 19:56 GMT
No, my computer does NOT have SP3.  Any other suggestions (she asks
hopefully...)?

> I haven't seen what you're describing, but I have heard recently of issues
> connected with using Access 2003 after applying the SP3.  Any chance your PC
[quoted text clipped - 19 lines]
>>
>> shajack2000 at yahoo.com
Jeff Boyce - 27 Nov 2007 22:43 GMT
In addition to your post here, have you tried searching on-line?

Regards

Jeff Boyce
Microsoft Office/Access MVP

> No, my computer does NOT have SP3.  Any other suggestions (she asks
> hopefully...)?
[quoted text clipped - 22 lines]
>>>
>>> shajack2000 at yahoo.com
Sharon V - 27 Nov 2007 23:17 GMT
Yes!  I have posted to numerous newsgroups and searched all over
on-line.  Usually I am pretty good with finding answers but, this time,
I've only come across 2 similar situations, one person had something
like that happen a while ago and had to something to do with ADO in the
registry (but that was all the info I got) and the other person had
installed some sort of widget which messed him up.  He doesn't remember
what exactly he installed, but remembered he had a hard time
uninstalling it and had to do some manual clean up with his registry to
fix the problem.

> In addition to your post here, have you tried searching on-line?
>
[quoted text clipped - 29 lines]
>>>>
>>>> shajack2000 at yahoo.com
Jerry Whittle - 29 Nov 2007 19:47 GMT
With Access shut down, put the following in the Start, Run window and see if
this fixes it. It will reregister the wizard. Make sure that you put in the
right path to the file.

regsvr32 "c:\Program Files\Microsoft Office\OFFICE11\acwztool.mde"

Make sure that you have the correct path. Read more about it at:
http://eis.bris.ac.uk/~ccmjs/accesswizard.html
Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> Yes!  I have posted to numerous newsgroups and searched all over
> on-line.  Usually I am pretty good with finding answers but, this time,
[quoted text clipped - 39 lines]
> >>>>
> >>>> shajack2000 at yahoo.com
Sharon V - 29 Nov 2007 20:06 GMT
thank you!  I will not be at my office until Monday but will try it then
and let you know.j

Sharon

> With Access shut down, put the following in the Start, Run window and see if
> this fixes it. It will reregister the wizard. Make sure that you put in the
[quoted text clipped - 4 lines]
> Make sure that you have the correct path. Read more about it at:
> http://eis.bris.ac.uk/~ccmjs/accesswizard.html
Sharon V - 03 Dec 2007 21:25 GMT
> With Access shut down, put the following in the Start, Run window and see if
> this fixes it. It will reregister the wizard. Make sure that you put in the
[quoted text clipped - 4 lines]
> Make sure that you have the correct path. Read more about it at:
> http://eis.bris.ac.uk/~ccmjs/accesswizard.html

that wasn't it either.  Oh well, thanks for trying to help me.  Guess
I'm just going to have to live with it.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.