Access and MS Word Mail Merge

[PNR]

I transferred my MS Access 2000 database to a new computer. I can open it in
2003 Access, but am keeping it in the 2000 version until I get it working
correctly.

I have dozens of Word documents where I use various Access queries as my
datasource. Now when I try to mail merge in Word (for some, not all, of my
documents.) Word mail merge message may say it can't find the data source.
So it gives me a data selection box and I choose my transferred database as
my datasource. Then it may show me a list of my tables in MS Access, but it
doesn't show all of my queries. Or if I pick a table or query it does show
for my data source and then do the merge, it gives me a series of "field
calculation occurred errors".

I notice in the data selection box, instead of typing in my tranferred
database as my chosen file, it also gives me the option of connecting to a
new data source and my choices are "new data source", or "new sql server
connection". I've also noticed the data selection box gives an option of a
new source and choices of "ms sql" "odbc sdn", "oracle" or other/ advanced.
Should I be doing anything with this?

I also run reports in Access. Now when I run reports, they are blank except
for the headings.

It seems it is not recognizing the data that is obvious and visible to me.

Any ideas?

 

[DL]

Perhaps keep a backup copy of your Access2k db, convert your db to Access
2003 then work through the errors.
I had v.few problems converting an Access2k db
and no you should'nt be using other data sources, as you listed