Union Query question from FoxPro database

[Shanin]

I have a question if this will work. We use a FoxPro software for our
payroll. Current data is stored in table tktimcrd. Quarterly, to reduce the
size of the active database, we are supposed to archive this, which I have
yet to do since we just got it. That data is stored in table tk_arch.

I created forms in access so we can run custom reports from the current
table tktimcrd. I'm thinking to avoid confusion among staff and having two
separate queries for everything and having to relay what information has been
archived, could I just create a union query to pull that information from
both tables and then base my other queries off of that? What happens now is
most reports require a date range to be entered. Would that screw things up
if part of the date range is in table tktimcrd and part in table tk_arch? I
tried to make a test query but I kept getting ODBC error #200. I don't know
if that is because nothing is in tk_arch yet or if I'm just missing
something. The fields in the two tables are identical.

 

[Ross]

I tried to make a test query but I kept getting ODBC error #200.

I'm having what appears to be the same problem. Tried following the work
around advised in KB 244904 to no avail. No abiilty to Union is a serious
set-back.

 

[Shanin]

I tried that work around and I think it worked. I say I think because I
don't have any data in my archive table yet so I'm not sure, but it did pull
up everyone's name from the current table. The only thing is I had to select
where it was. After I typed in the SQL, a screen popped up and I had to
choose machine and the location of my ODBC. That won't work for anyone else
since they wouldn't have a clue as to what it was asking them. I wonder if
there's a way just to make a table off each and then join the two tables??