Unable to merge after sharing database

J

James

What did I leave out?

Added security in access 2003 and lost the abbility to merge with word 2003!
 
J

Joan Wild

Could you provide more details?

What error message are you getting?

Are you merging from within Access, or from Word?

What steps did you take?
 
J

Joan Wild

If you want to do it from within Word, you'll need to be joined by default
to your secure workgroup file.

I would also suggest you open Word, Tools, Options, General tab and ensure
that 'Confirm conversion on open' is checked.

Start the merge, and when you select the data source, choose your secure mdb
file. In the 'Confirm Data Source' dialog choose 'via DDE' and you'll be
prompted for the Access username/password to open the data source.

This is the only way I've found to succeed from within Word.

You could, instead, do the merge from within Access. Since you would have
already signed in to the Access database, you're already authenticated for
the Access security. Use Tools, Office Links, Merge it with Word and
proceed from there.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top