Access can not find a table in append query

[Tom]

Hi all,

I have a table called MyCustomers.
For some reason, when I try to create Append query, it doesnt show on the
list of tables.
I know the the table is there and I can select it if I want to create a
different type of query but not append.

What can cause that?

TIA,

Tom

 

[boblarson]

Does your table have a PRIMARY KEY defined?
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

 

[Tom]

yes it has.

Does your table have a PRIMARY KEY defined?
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

 

[Tom]

Yes, it does have primary key.

Does your table have a PRIMARY KEY defined?
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

 

[boblarson]

That's the only reason I could think of why it wasn't showing up. I would
need to see the database to figure it out then. If you wish you can email it
to me at bob at btlarson d0t c0m.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

 

[John Spencer]

Is the table an Access (jet) table?
Or is it a linked table?
If it is a linked table, what is the source of the table?

If you open the table directly can you add records to the table in datasheet
view?

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[A-Lo]

Is the table an Access (jet) table?
Or is it a linked table?
If it is a linked table, what is the source of the table?

If you open the table directly can you add records to the table in datasheet
view?

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
.







- Show quoted text -

I am having the same issue. I've never had this problem before. In
my situation, I have 2 tables that are linked tables that I want to
append to an access table that I created. The access table I created
for the appended data to go to does have a primary key, I am able to
type into the datasheet view, but it is not visible on the drop down
selections on the append query. The 2 tables I want to append are the
linked tables. They do show up on the drop down list. Does this have
something to do with my issue?

Thanks!

 

[boblarson]

When you say it doesn't show up in the list, are you saying it doesn't show
up in the list of tables to TAKE data from to append to another table, or in
the list of tables to append to? If the latter, are you sure you don't
actually have that table in the query already because it won't let you append
to itself.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.