access 2003 table not visible in append query

[Mo]

Hello,

Has anyone experience of this problem?

I have a database with three tables - lets call them 'tblA', 'tblB' and
'tblC'. Structurally, they are all the same. 'TblA' has no data. 'TblB'
has four records. PK in all tables is autonumber. All other fields are text.

I want to append the records from 'tblB' to 'tblA'. In the query window,
I create a new query and add 'tblB'. I now change the query type to an
append query. At this point the 'Append To' window pops up asking me
which table I want to append to. I want to select tblA. I click on the
'Table Name' drop down box to select the table, and low an behold, tblA
is not there!!

Confused, I close the query window and check that the table is really
there by clicking on the 'Tables' tab. Yes, it is. I create a new query
and try again. Same result. After a bit of experimentation, I work out
that the first table listed alphabetically is never present when I
create an append query. I have created another table, called 'tblAA',
and tried the query again. Once again, 'tblA' is missing but 'tblAA' is
there!

There is nothing unusual in the db. It's a simple .mdb file with no
linked tables. The database itself is one I created today to try to get
to the bottom of this problem when I noticed it occurring in another
database.

Incidentally, I can append to 'tblA' if I write the SQL myself instead
of using query design.

So what's going on?

TIA for any help.

 

[Allen Browne]

This is a bug that occurs with Service Pack 3 of Access 2003.

Try applying this hotfix:
http://support.microsoft.com/kb/945674
I can't recall if it addresses this problem, but it does address several
issues:
http://allenbrowne.com/bug-Access2003SP3.html

As a workaround, you can select the wrong table. Then switch to SQL View
(View menu), and type the correct table in place of the wrong one.

Either that, or create another table that sorts above your first one.

 

[Mo]

This is a bug that occurs with Service Pack 3 of Access 2003.

Try applying this hotfix:
http://support.microsoft.com/kb/945674
I can't recall if it addresses this problem, but it does address several
issues:
http://allenbrowne.com/bug-Access2003SP3.html

As a workaround, you can select the wrong table. Then switch to SQL View
(View menu), and type the correct table in place of the wrong one.

Either that, or create another table that sorts above your first one.

Yeah, thanks Allen. I figured out the workaround. I'll try the hotfix.

 

[Mo]

Mo wrote:


The hotfix fails when I run it ('Installatioan ended prematurely because
of an error').

Any ideas?

 

[Mo]

This is a bug that occurs with Service Pack 3 of Access 2003.

Try applying this hotfix:
http://support.microsoft.com/kb/945674
I can't recall if it addresses this problem, but it does address several
issues:
http://allenbrowne.com/bug-Access2003SP3.html

As a workaround, you can select the wrong table. Then switch to SQL View
(View menu), and type the correct table in place of the wrong one.

Either that, or create another table that sorts above your first one.

Just to confirm that once I finally managed to install the hotfix on my
PC, it didn't resolve this particular issue.

Thanks again.