Append Query

  • Thread starter Thread starter DSmith
  • Start date Start date
D

DSmith

We have just moved up to Office 2003 after using Office 2000. In Access
2000, I could bring in a new table of data every month and name it the same
as the previous month and the append queries would work great. In 2003, the
queries do not recognize the new table even though it is named the same. Is
there anything I can do? Thanks.
 
This may be a byproduct of the Name Autocorrect feature, which is what is
used to create the object dependencies. Maybe when the object gets deleted,
Name Autocorrect logs that, and then Access assumes it's not there. This is
a total guess, but try it and see.

Perhaps if you describe your process of "bringing in a new table", it will
shed some light on the situation.
 
Well, I was having some other problems and was advised to turn off
Autocorrect which I did.

We use a scanner to grade tests. At the end of the month, I import all the
scores into Access as a new table replacing the table from the month before.
Fields are named the same as is the table. The queries in the past have just
hooked back up to the table. In 2003 Access, this is not the case. Access is
not recognizing the new table as the same and is dropping all the
relationships. Would turning Autocorrect back on solve the problem?
 
If the table has relationships, then I would not delete and recreate it
each time. Instead, leave that table permanant. Do import the data to a
non-linked table, just standalone. Deleting and recreating it should not be
a problem.

If the query still thinks it doesn't exist, then try storing the query in
code, and running from VBA. This way, no dependency exists, and the query
will simply look for the table each time.

Maybe.
 
Back
Top