P
PNR
I transferred my 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 right.
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 transferred
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?
but am keeping it in the 2000 version until I get it working right.
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 transferred
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?