 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / November 2007Access 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 Does your table have a PRIMARY KEY defined?  SignatureBob 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. > Hi all, > [quoted text clipped - 9 lines] > > Tom yes it has. > Does your table have a PRIMARY KEY defined? > [quoted text clipped - 12 lines] >> >> Tom 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. SignatureBob 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. > yes it has. > > Does your table have a PRIMARY KEY defined? [quoted text clipped - 13 lines] > >> > >> Tom 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? SignatureJohn Spencer Access MVP 2002-2005, 2007 Center for Health Program Development and Management University of Maryland Baltimore County . > 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 [quoted text clipped - 19 lines] >> >> >> >> Tom > Is the table an Access (jet) table? > Or is it a linked table? [quoted text clipped - 49 lines] > > - 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! Yes, it does have primary key. > Does your table have a PRIMARY KEY defined? > [quoted text clipped - 12 lines] >> >> Tom 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. SignatureBob 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. > Hi all, > [quoted text clipped - 9 lines] > > Tom |
Reply to this Message |
 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.