Group:  Microsoft Word ยป microsoft.public.word.mailmerge.fields
Thread: datasource is in use -> can't connect to database

Geek News

datasource is in use -> can't connect to database
"b.schmidt" <shocker843[ at ]hotmail.com> 4/27/2007 11:06:30 AM
hi,

I wrote a Word 2007 Add-In in C#, which imports my recipients from a csv
file I created.

This is the code I use:

--------- doc.MailMerge.OpenDataSource(addressFileName, ref formatObj,
ref trueObj, ref trueObj, ref trueObj, ref falseObj,
ref missing, ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing, ref missing,
ref falseObj, ref missing);
---------

This works fine, but when I want to send out the mailmerge, or want to
edit specific records, an error message pops up, which says that it
can't connect to the database. But when clicking ok, all fields are
filled out, as it should be.. ?!?

I found out, that Word is locking my csv-file with the contacts (so that
you cannot rename or delete the file). Maybe this is the problem,
because when I want to print or edit specific records (which is a new
Word window), it seems to create a new instance of Word and can't open
the CSV-file because it is already used by my initial Word window.

Any ideas how to solve this issue?

best regards,
Bernhard
Re: datasource is in use -> can't connect to database [solved]
"b.schmidt" <shocker843[ at ]hotmail.com> 4/27/2007 12:56:42 PM
ok, forget it. :P

I had a CSV field "CampaignEntryID", and as it seems the Business
Contact Manager thought that the recipient list belogns to him and he
tried to connect to a datase.

I just took this field away, and now it works. :)

best regards,
bernhard

b.schmidt, am 27.04.2007 13:06:
[Quoted Text]
> hi,
>
> I wrote a Word 2007 Add-In in C#, which imports my recipients from a csv
> file I created.
>
> This is the code I use:
>
> ---------
> doc.MailMerge.OpenDataSource(addressFileName, ref formatObj,
> ref trueObj, ref trueObj, ref trueObj, ref falseObj,
> ref missing, ref missing, ref missing, ref missing,
> ref missing, ref missing, ref missing, ref missing,
> ref falseObj, ref missing);
> ---------
>
> This works fine, but when I want to send out the mailmerge, or want to
> edit specific records, an error message pops up, which says that it
> can't connect to the database. But when clicking ok, all fields are
> filled out, as it should be.. ?!?
>
> I found out, that Word is locking my csv-file with the contacts (so that
> you cannot rename or delete the file). Maybe this is the problem,
> because when I want to print or edit specific records (which is a new
> Word window), it seems to create a new instance of Word and can't open
> the CSV-file because it is already used by my initial Word window.
>
> Any ideas how to solve this issue?
>
> best regards,
> Bernhard

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net