Reply
 
Thread Tools Display Modes
  #1   Report Post  
RS200Phil
 
Posts: n/a
Default Word 97 opening Access 2000

Hi,

As a developer, to support various clients and legacy systems, I have
Word 97 and 2000, and Access 2/95/97 and 2000 all installed on my Win
98se PC.

This has worked absolutely fine for years. However, tonight, when I
attempted a mailmerge with Word 97, it used Access 2000 to open an
Access 97 database. It has always correctly used Access 97 in the
past.

I believe this was probably caused by my having Access 2000 open (doing
something else) at the time, but after rebooting etc. Word 97 now
refuses to open Access 97, insisting on running 2000 every time.

I am sure this is just a registry setting - I don't fancy uninstalling
both, reinstalling and setting preferences and loading service packs.
Surely it's a one-liner?

Can anybody tell me what I need to change?
Thanks in anticipation.

Phil

  #2   Report Post  
Peter Jamieson
 
Posts: n/a
Default

It may be a one-liner but at the moment I can't find it. Could it be in
WINWORD.INI? Suggestions:
a. ensure you do not have a PATH that has the Access 2000 .exe before the
Access 97 .exe. Sounds unlikely though.
b. try to reverse what has happened by doing exactly the same thing the
other way around, i.e. have Access 97 open then try to connect using DDE.

Peter Jamieson
"RS200Phil" wrote in message
oups.com...
Hi,

As a developer, to support various clients and legacy systems, I have
Word 97 and 2000, and Access 2/95/97 and 2000 all installed on my Win
98se PC.

This has worked absolutely fine for years. However, tonight, when I
attempted a mailmerge with Word 97, it used Access 2000 to open an
Access 97 database. It has always correctly used Access 97 in the
past.

I believe this was probably caused by my having Access 2000 open (doing
something else) at the time, but after rebooting etc. Word 97 now
refuses to open Access 97, insisting on running 2000 every time.

I am sure this is just a registry setting - I don't fancy uninstalling
both, reinstalling and setting preferences and loading service packs.
Surely it's a one-liner?

Can anybody tell me what I need to change?
Thanks in anticipation.

Phil



  #3   Report Post  
RS200Phil
 
Posts: n/a
Default

Thanks very much indeed for the suggestions, Peter. Sadly I had no joy
with these.

If in Word, you choose Tools / Mail Merge / Get Data then choose an
Access database as the datasource, it will open A2K. I reset the file
association, just in case, so if you click on the same MDB files in
Explorer it correctly uses A97. Word / merge still insists on A2K,
though. Aaargh!!!!

Unless I have (or receive!) any inspiration in the next couple of days
I'll just uninstall O'2K and re-establish the merge. I presume it will
then have to use O'97. Then I'll reinstall O2K again.

Sounds logical enough to me, but I'm really hoping to get to the bottom
of this...

Anyone else got any ideas?

Thanks again.

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Basic macros query - where are they assigned to? Bert Coules New Users 15 January 18th 05 01:28 PM
How do I create & merge specific data base & master documents? maggiev New Users 2 January 13th 05 12:30 AM
word xp crashes after macros are recorded kharris0405 Microsoft Word Help 3 January 11th 05 11:50 PM
WP Delay Code - Word Equiv Mike G - Milw, WI Microsoft Word Help 6 January 10th 05 05:12 PM
Opening Access from Word Slow Learner Microsoft Word Help 10 January 10th 05 12:18 PM


All times are GMT +1. The time now is 12:24 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"