Choice of Starting Access.

[TerryM]

I have a mailmerge document which uses an Access2000 DB as
it's data source. I had created an autoexec macro to
import data, validate, clean it, etc. However it takes
too long for the mailmerge to work to I thought I should
split it into two parts.

1 - Manually import/update the data.
2 - Do the mailmerge without doing anything to the data.

How can I start the DB in the two different ways? I've
tried using the /cmd and /x options but I cannot get them
to work!!

Help.... please.

 

[Gary Miller]

Terry,

Open the database normally and present the user a form with
two buttons giving them a choice of what to do. Move your
code out of the Autoexec and behind each appropriate button.

Gary Miller
Sisters, OR

 

[TerryM]

Thanks for the suggestion but ... I have the database as
the source for mailmerge. The Word document opens the
Access DB and links the data. I dont want to give the
user a menu to choose from. If however they want to run
the database outside the mailmerge then I can certainly
display a menu system.

Can you see my problem?

 

[Gary Miller]

Terry,

No, I guess I really don't understand the problem.

When you say....
... I assumed that you were opening the database. Where is
the autoexec you refer to? In Word or Access?

I have never seen just linking to Access tables from a Word
Merge trigger an Autoexec in Access. Are you doing the
cleanup on the Word end???

Maybe a little more info would give a clearer picture.

Gary Miller

 

[Albert D. Kallal]

Well, the solution is to always runt the mail merge from ms-access, and NOT
to allow the word doc to attach to the ms-access application.

Check out how my sample functions, and read the notes as to why I choose
this approach.

You can find this working example at:

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html