documents and datasources

  • Thread starter Thread starter Jon C. Munson II
  • Start date Start date
J

Jon C. Munson II

hello all!

i have a quandry (as we all do...)...

i have an Access2000 application that calls Word2000 programmatically,
opening a doc template and running a merge. works great, no probs.

we bought a new box and have Office XP Pro & WinXP on that machine.

after converting the Access app and trying the same calls, i now get "Word
cannot find the datasource" or "this is not a mail merge main document..."
when attempting to recreate/redefine the data source, the DS doesn't "stick"
to the document (even retyping the document from scratch, etc., doesn't
work!). trying programmatically to assign the DS to the doc, etc., results
in equal frustration (similar error messages or failed code).

also, in one document that does work, the data (having only recently been
repopulated by the Access app) doesn't show up for a few seconds (meaning i
have to re-merge until the data is magically there, e'en though it has
actually been there for some time). this looks like a case of data refresh
problems (data not appearing to other applications due to timeliness of some
kind) as after a few seconds, or a couple of merge attempts, later, the doc
works with no changes.

this is extremely frustating and i can't find an answer readily.

anybody got suggestions/solutions?

the data is local, and the IE settings are to trust the local intranet (i
checked that just to be sure). the database is in shared mode.

thanks for the help in advance!

jon
 
p.s. i'm now getting, which i wasn't before, a "operation cannot be
completed due to dialog or database engine failures. please try again
later." message.

ok, ms, what the heck did you do now?

i checked the "read only" attribute (having found an issue similar in
PUB2002 in the KB) and that isn't the problem as i can see some of the
queries in the DB...

EXTREMELY FRUSTRATING HERE GUYS!!!

jon
 
Hum, hard to figure out what the exact problem here is.

However, I am going to suggest you give my mail merge example a try (it
likely is less work to use my example then to figure out your problem!).

So if you don't get any other answers in this thread...then give my mail
merge stuff a try. You can find it here:
http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html

If the above sample works for you...then at least you "know" you can get
something to work.

And, if you like it...feel free to use it in your application (you should
read all the notes on my web site on how to get this working).

Good luck!
 
ok, while i'm not enthused that MS has chosen to 'break' a 'native' merge
with Access, i'm happier with creating the CSV file.

the solution you have coded works well enough, sorry i didn't think of it
sooner :D i haven't done any real serious programming for some time now and
i'm a bit rusty...i pared it down to what i needed and it works spiffy.

thank you for posting it.

jon
 
Back
Top