Table missing when running an <Append Query>

[jamathern]

Here is the scenario...

--> I am running Microsoft Access 2003 at work. I have had numerous IT
personnel look at my problem. They all came back with the same
answer..."blank stares"

--> I open a new DB. I append 2 basic excel files as tables. I select
to use header row as header columns. Like I said very basic. This
problem also exists when creating 2 blank tables. I would name them
table1 and table2.

--> My objective is to append table2 to table1. So I open a new query
in design view. I select to show table2. I go to the query selection
and select <append query>. After this there is a drop box with my
table selections. Only table2 is available!!! I can manually type
table1 in the selection box and it will successfully bring up table1
to append to. But it is NOT a Selection for me to pick!

--> Where is my table1??? On my main page of the DB where it shows all
my tables I see Table1 and Table2.

--> Here is the kicker...Imagine my main table page where it shows
table1 and table2. The table that is always missing in selection of
tables from my <append query> is always the 1st table listed in my
main page of tables.

--> So, no matter what table I have listed in my table main page the
1st one is always the one missing. I could have 10 tables. If they
were listed Table1 through Table10 and Table1 being listed 1st, that
would be the only table missing from the selection box of tables to
append to.

--> I have reinstalled Access. I have changed from 2003 to 2000 file
format and nothing works. I started with a detect and repair which
came back successful with no errors. I reset everything to default.
When I go to another computer at work with that SAME DB I am working
on everything works just fine. Table1 is there to append to.

--> So I have narrowed it down to being defiantly a local computer
issue. I am thinking it has to be in the registry because a reinstall
didn't work. I have updated my office 2003 with the most current
service pack. I really hope someone out there in the world has an
answer for me! Next step is formating my hard drive. I really want to
refrain from doing that!

 

[Tom Wickerath]

I am thinking it has to be in the registry because a reinstall

didn't work.

However, reinstalls often times will not replace corrupt files. The
installer "sees" that the file is present, so it saves a few milliseconds by
not overwriting the file.

I cannot say whether this will help, but try the following for
wizard-related problems. This is my standard boilerplate text (I didn't
attempt to edit any of it for your specific situation):

Replace three files on your hard drive, Acwzmain.mde, Acwzlib.mde and
Acwztool.mde, using the instructions shown in KB 303769. One or more of these
files may have become corrupted. Do this without Access running.

http://support.microsoft.com/?id=303769
http://support.microsoft.com/?id=833220 <--> Error in loading DLL

1.) Insert the Microsoft Office or Access compact disc.
2.) By using Windows Explorer, open the Pfiles\Msoffice\Office\1033
folder on your CD-ROM or DVD-ROM drive, and locate the
Acwzmain.mde, Acwzlib.mde and Acwztool.mde files.
3.) Select these files, and then click Copy on the Edit menu
4.) Open the folder that you installed Office into. The default folder is
C:\Program Files\Microsoft Office. Select the Office\1033 folder,
and then on the Edit menu, click Paste.

If that doesn't fix the problem, try re-registering the Accwiz.dll,
Msado15.dll and DAO360.dll files.
Click on Start > Run. Then enter the commands:

Regsvr32 Accwiz.dll
Regsvr32 "C:\Program Files\Common Files\system\ado\Msado15.dll"
Regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\Dao360.dll"

Wizard starts, but “No valid fields can be found†error message may be
related to overly aggressive settings on antivirus software
http://groups.google.com/group/micr..._frm/thread/287b312d799c6739/2543458dbca8ddde
and
http://alexdyb.blogspot.com/2006/02/be-careful-with-kaspersky-anti-virus.html

Access 2003 Users:
BUG: List of currently linked tables may not appear in
Linked Table Manager Wizard in a database in Access 2003
http://support.microsoft.com/?id=835519

Notes:
1. To find Accwiz.dll in Win. XP Professional, I had to make sure to place a
check on Advanced Options in the search dialog, with Search system folders
and Search Subfolders checked.

2. Although I received a message indicating success, when using regsvr32, I
found that the path was not updated. I had to manually update the value of
this key on my PC.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________