Re: Append Query Problem

Allen,

Thanks for your quick reply again.

From your reply, i tried a couple things. The drop down is missing the
first table from the table list. If I add a blank table (1 field, but no
records) named "C", I see my linkslist table. If I rename it to "Z", I no
longer see my linkslist table.

Does this make sense?

I at least have found a workaround, but the cause doesn't make sense.

Any ideas as to what is going on?

Keith

"Allen Browne" wrote:

So if you copy the table into a new database, it does appear.
But if you then create the relationships, it disappears???

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Texernie1" <khenders_98athotmaildotcom@xxxxxxxxxxx> wrote in message
news:EAF9C12D-6257-4748-958C-1C4D589F4D40@xxxxxxxxxxxxxxxx
Allen,

Thanks for the quick reply. Here are the results:

1.1 - Yes
1.2 - Yes
1.3 - No
1.4 - No
1.5 - No
2. Completed - didn't help.
3. Yes to both
4. returns "linklist"
5. Completed all steps including importing into a blank database.

The problem still exists.

If I copy the table to another table not in the relationships, I can see
it
in the append query drop down. Could this be a problem with my
relationships?

Thanks in advance.

Keith.


"Allen Browne" wrote:

Ouch. Something's haywire, here Keith.

1. Double-check these things:
1.1 You can see your linklist table in the Database window.
1.2 You can open it there and view the data.
1.3 There is no spurious character in the table name (such as a space.)
1.4 It is not an attached table, linked to a back end that is missing.
1.5 This is not a secured database, so it's not a permissions issue.

2. If that checks out, work through this standard recovery sequence:
http://allenbrowne.com/recover.html
It's designed to fix the most common problems in Access.

3. If you are still stuck, see if this query returns your linklist table:
SELECT MSysObjects.Name
FROM MSysObjects
WHERE MSysObjects.Type = 1
ORDER BY MSysObjects.Name;
If it does, type the table name into the Criteria row under the name
field.
(This re-verifies the name is correct.)

4. Open the Immediate Window (Ctrl+G), and enter:
? CurrentData.AllTables("linklist").Name
In Access 2000 and later, there are 2 internal canonical lists of tables.
There is a (fairly rare) form of corruption where these 2 lists get out
of
sync. If this happens, the table will show up in #3 but not in #4, or
vice
versa.

5. See if this query works:
SELECT linklist.* FROM linklist;
If it does, try turning it into a Make Table query, to make a new table.
You
could then create a new (blank) database, import the other 2 tables and
the
one you just made, create the relationships, and you are back in
business.

Note: Don't skip the steps of #1 and #2. Chances are it will be fixed by
that stage.

"Texernie1" <khenders_98athotmaildotcom@xxxxxxxxxxx> wrote in message
news:BAD50F41-5C40-4655-856E-1168A65C06FA@xxxxxxxxxxxxxxxx
I have 3 tables in the database. When I go to create the append query,
only
2
of the tables show up in the dropdown to select the table to append to.
The
table I need to append to is the 3rd table (named linklist), which
doesn't
show up.

I can select one of the other 2 tables. When I try to modify the raw
SQL
to
use the linklist table, I get a syntax error in INSERT INTO statment
when
I
try to go back to the grid view.

All 3 tables are part of relationships. I am using Access 2003 SP3.


.

Relevant Pages

  • Re: A little more meat this week
    ... said data includes lists." ... implementation with a query processor capable of returning a result set ... then we can call it a result bag (SQL ... I'm looking at the data model and not database tools at this ...
    (comp.databases.pick)
  • Re: Data sources for different mailmerge letters
    ... try the following (I'm not going to go along the Query route ... In another database, I have Test B with "Verbal Comprehension" field, ... If you have two OALs (Office address lists) with identical data fields, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: qeury other list using input from selected item in current list
    ... With SPQuery you can query a list based on a CAML (Collaborative Application ... query" objects from different lists or objects in your site collection. ... the query and the database which the query ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Append Query Problem
    ... Completed all steps including importing into a blank database. ... > in the append query drop down. ... see if this query returns your linklist>> table: ... >> In Access 2000 and later, there are 2 internal canonical lists of>> tables. ...
    (microsoft.public.access.queries)
  • Checking for Missing and Extra data on Questionnaires
    ... I am working on a database which did not have validation ... so 'missing' and 'extra' data typically happen as a result ... creating two queries for each question; a 'miss' query ...
    (microsoft.public.access.queries)
Loading