Re: Word 2003 Closes upon update of sort order of table using Acce

sorry for adding the other threads, wasn't sure of
the process.

No problem - people sometimes do it when they don't get a reply, but sometimes that can be because the original responder is away for a while, as in this case.

Yes this is still a DDE

OK, I don't think the situation has changed for DDE from the one I described in my earlier message. i.e. what you probably have to do to avoid all the problems is both the "TOP 1000" /and/ change to OLE DB. I suspect in your case the problem then is that you are using a secure database and in that case there is an additional problem because you may have to use a .odc file to get Word to connect to the database, and/or end up embedding the necessary security informaiton somewhere inside the Word document.

But can you confirm/deny that the secure database thing is the reason why you haven't moved to OLE DB? If not, what is? Are you using workgroup security rather than a database password?
--
Peter Jamieson
http://tips.pjmsn.me.uk

"KMikaela" <KMikaela@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:D1102DB5-ABDB-4432-82AA-45F55F10D17E@xxxxxxxxxxxxxxxx
Yes this is still a DDE, sorry for adding the other threads, wasn't sure of
the process.

Mikaela

"Peter Jamieson" wrote:

Is this still DDE (as your other messages suggest) or is it OLE DB now?

--
Peter Jamieson
http://tips.pjmsn.me.uk

"KMikaela" <KMikaela@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:84E1CE35-562D-435A-AE68-098E2ED42296@xxxxxxxxxxxxxxxx
> Dear Peter,
>
> It seems the "Find Entry" button on the Mail merge tool bar only works
> after
> you open the "mail merge recipeients" Is this because the items in the
> data
> source have changed and it is a query? Is there a way to set this to > do
> automatically or are users going to have to refresh this each time they
> enter
> a template? I have well over 200 templates in use, and I am at a loss > for
> why there are so many issues with mail merge in Word 2003.
>
> Many thanks,
>
> Mikaela
>
> "KMikaela" wrote:
>
>> Hi Peter,
>>
>> > Have you tried defining an Access query that selects the necessary >> > 1000
>> > records and using that as the data source?
>>
>> This is exactly what I'm doing, so it is working well.
>>
>> Thank you.
>>
>> "Peter Jamieson" wrote:
>>
>> > Hello Mikaela
>> >
>> > > Also, I have been
>> > > using the Find record button on the Mail Merge tool bar, sorry for
>> > > not
>> > > being
>> > > clearer.
>> >
>> > FWIW It is not your fault or my fault that it does not work, and >> > that
>> > this
>> > kind of predefined limit is not specified.
>> >
>> > <<
>> > > as I had tried the OLE
>> > > DB connection and it doesn't see the table in Access at all So I >> > > will
>> > > just
>> > > need to filter all tables as we only search the
>> > > most recently entered records.
>> >
>> > Have you tried defining an Access query that selects the necessary >> > 1000
>> > records and using that as the data source?
>> >
>> > -- >> > Peter Jamieson
>> > http://tips.pjmsn.me.uk
>> >
>> > "KMikaela" <KMikaela@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> > news:B843E890-6826-4845-A75C-E60E3AE12F75@xxxxxxxxxxxxxxxx
>> > > Dear Peter,
>> > >
>> > > Thank you so much for your detailed and quick reply. I had >> > > thought
>> > > it
>> > > might
>> > > be the number of records in Word 2003 but had not found any data >> > > to
>> > > indicate
>> > > the total capacity of records (they really should write that down
>> > > some
>> > > where
>> > > - but I gues most people don't use mail merge for more than 10,000
>> > > records),
>> > > although it worked beautifully in Word 2000, ah well. Also, I >> > > have
>> > > been
>> > > using the Find record button on the Mail Merge tool bar, sorry for
>> > > not
>> > > being
>> > > clearer.
>> > >
>> > > Prior to receiving your email I had tried putting a filter on the
>> > > table to
>> > > only pull the top 1,000 records and that worked well, as I had >> > > tried
>> > > the
>> > > OLE
>> > > DB connection and it doesn't see the table in Access at all, so it >> > > is
>> > > unable
>> > > to connect. So I will just need to filter all tables as we only
>> > > search
>> > > the
>> > > most recently entered records.
>> > >
>> > > I do appreciate your respons, I am very glad I could just confirm
>> > > what the
>> > > problem was, as there was nothing out there saying how many >> > > records
>> > > the
>> > > dialogue could hold, I now now how to proceed.
>> > >
>> > > Many thanks,
>> > >
>> > > Mikaela
>> > >
>> > > "Peter Jamieson" wrote:
>> > >
>> > >> Unfortunately, there is a cluster of unhelpful problems in this
>> > >> area -
>> > >> i.e.,
>> > >> solving one usually means that you face another.
>> > >>
>> > >> To recap...
>> > >>
>> > >> 1. Using the Find in Field function from (e.g.) the Mailmerge
>> > >> toolbar
>> > >> fails, certainly with this type of data source and connection >> > >> type
>> > >> (DDE).
>> > >>
>> > >> 2. Using the Find button from within the Mail Merge Recipients
>> > >> dialog
>> > >> box
>> > >> seems to work OK here, but
>> > >> a. it can take a long time to populate the dialog box
>> > >> b. the dialog box only holds 10,000 records, and Word can >> > >> crash
>> > >> if
>> > >> you
>> > >> have more (in fact,Word's processing clearly changes at the >> > >> 10,000
>> > >> record
>> > >> mark in other places that do not have anything to do with this
>> > >> dialog box
>> > >>
>> > >> 3. You can solve (1) and 2(a) by using OLE DB to connect. >> > >> However,
>> > >> a. the dialog box still only holds 10,000 records and the >> > >> Find
>> > >> button
>> > >> in
>> > >> the box will not find a record beyond that
>> > >> b. there are potentially several reasons why an OLE DB
>> > >> connection
>> > >> will
>> > >> not work for you
>> > >>
>> > >> 4. You can work around 3(a) by using the Find button on the
>> > >> MailMerge
>> > >> toolbar rather than the Find button in the Mail Merge Recipients
>> > >> Dialog
>> > >> box.
>> > >> You may also notice that the dialog itself is different - with >> > >> DDE,
>> > >> you
>> > >> have
>> > >> to select a field to search.
>> > >>
>> > >> 5. The question is, can you work around all the problems alluded >> > >> to
>> > >> in
>> > >> 3(b),
>> > >> which include:
>> > >> a. can you connect to a workgroup-secured database via OLE DB? >> > >> If
>> > >> so,
>> > >> can
>> > >> you do so in a way that does not significantly undermine >> > >> workgroup
>> > >> security
>> > >> (e.g. by embedding plain text login/password info in the Word
>> > >> document or
>> > >> ..odc file)?
>> > >> b. can OLE DB "see" the tables/queries you want to use - e.g. >> > >> are
>> > >> they
>> > >> linked tables or parameter queries? And if they are parameter
>> > >> queries,
>> > >> how
>> > >> do you get Word to ask for the paramters?
>> > >> c. does OLE DB return the records you expect (e.g. it probably
>> > >> won't if
>> > >> you
>> > >> are using wildcard characters in LIKE expressions in queries.
>> > >> d. perhaps other stuff that I have forgotten.
>> > >>
>> > >> 6. So can you tell us which of those problems you would need to
>> > >> overcome
>> > >> or
>> > >> any other reasons why you couldn't move to OLE DB?
>> > >>
>> > >> -- >> > >> Peter Jamieson
>> > >> http://tips.pjmsn.me.uk
>> > >>
>> > >> "KMikaela" <KMikaela@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> > >> news:3D376B8B-51CE-42AF-A9FB-732AD93CBABF@xxxxxxxxxxxxxxxx
>> > >> >I also have the issue of word closing, and have recently >> > >> >upgraded
>> > >> >from
>> > >> > Windows 2000 to Windows XP and from Office 2000 to Office 2003. >> > >> > In
>> > >> > templates
>> > >> > that functioned well before, the "find" command no longer >> > >> > locates
>> > >> > the
>> > >> > record
>> > >> > and when I try to save the sort order on the Access data, it
>> > >> > causes
>> > >> > word
>> > >> > to
>> > >> > close. The database table has over 19,000 records with 78 >> > >> > field
>> > >> > names,
>> > >> > so
>> > >> > I'm not sure if this poses a problem for word 2003, as it >> > >> > worked
>> > >> > well
>> > >> > in
>> > >> > 2000. I am using a secure database with a DDE connection so >> > >> > I'm
>> > >> > not
>> > >> > sure
>> > >> > if
>> > >> > that is the issue either. I have also installed the mso.dll >> > >> > fix,
>> > >> > but
>> > >> > still
>> > >> > having the same issue. We use over 20 templates with mail >> > >> > merge
>> > >> > to
>> > >> > this
>> > >> > table and users are having to scroll through endless records >> > >> > any
>> > >> > assitance
>> > >> > would be greatly appreciated.
>> > >>
>> > >>
>> >
>> >



.

Loading