|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 5th, 2007, 01:32 AM
posted to microsoft.public.access.queries
|
|||
|
|||
Access can not find a table in append query
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 
|
|
#2
November 5th, 2007, 06:18 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Access can not find a table in append query
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" wrote: 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
|
|
#3
November 5th, 2007, 07:30 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Access can not find a table in append query
yes it has.
"boblarson" wrote in message ... 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" wrote: 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
|
|
#4
November 5th, 2007, 12:43 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Access can not find a table in append query
Yes, it does have primary key.
"boblarson" wrote in message ... 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" wrote: 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
|
|
#5
November 6th, 2007, 04:06 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Access can not find a table in append query
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. "Tom" wrote: yes it has. "boblarson" wrote in message ... 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" wrote: 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
|
|
#6
November 6th, 2007, 12:37 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Access can not find a table in append query
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 .. "boblarson" wrote in message ... 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. "Tom" wrote: yes it has. "boblarson" wrote in message ... 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" wrote: 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
|
|
#7
November 8th, 2007, 07:40 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Access can not find a table in append query
On Nov 6, 6:37 am, "John Spencer" wrote:
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 . "boblarson" wrote in message ... 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 athttp://www.btabdevelopment.com __________________________________ If my post was helpful to you, please rate the post. "Tom" wrote: yes it has. "boblarson" wrote in message ... Does your table have a PRIMARY KEY defined? -- Bob Larson Access World Forums Super Moderator Utter Access VIP Tutorials athttp://www.btabdevelopment.com __________________________________ If my post was helpful to you, please rate the post. "Tom" wrote: 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- Hide quoted text - - 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!
|
|
#8
November 8th, 2007, 08:06 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Access can not find a table in append query
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. "Tom" wrote: 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
