Merge from Access DB

[RH]

I have Office Small Business XP (doesn't come with access) on one computer
and I want to be able to use Word XP and an Access XP DB for mailing labels
etc.

Is it possible to perform a merge if you don't actually have the Access
Program installed?? I get the error message that the DB is corrupt, but it
opens fine a machine that has Access XP installed.

thanks in advance

Robyn

 

[Cindy M -WordMVP-]

Hi Rh,

It should be possible, yes, but you have to watch the connection method you're
using. And it assumes that the necessary OLE DB or ODBC driver has been
installed. I'm not familiar with OSB (any flavor), so I'm not sure what
drivers are being installed for mail merge by default...

1) Unless you specify differently, Word 2002 will try to use OLE DB. I assume
this is where you're getting the error message. Please post the EXACT wording
of the message.

2) Try activating "Confirm conversions on open", then select the data source
file again. You should get a list of possible connection methods: Try ODBC and
see if that works.

I have Office Small Business XP (doesn't come with access) on one computer
and I want to be able to use Word XP and an Access XP DB for mailing labels
etc.

Is it possible to perform a merge if you don't actually have the Access
Program installed?? I get the error message that the DB is corrupt, but it
opens fine a machine that has Access XP installed.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail