.MDB vs .MDE for Distribution

[number2]

I have begun distibution of my db in .mde format. However, I would like to impliment mailing labels in my db. As discussed previously, printer setups CAN NOT be saved in .mde format. It only allows the use of the default printer, or one time use of a specific printer (the user would have to setup the printer EACH time the used the printer in .mde format)

I really need to impliment the mailing label feature. I am leary of distributing in .mdb format due to security and accidental user alteration issues.

However, in order to get mailing label functionality to my db, I am willing to distribute in .mdb format. Is this a mistake? Are there any other reasons why I should avoid distribution in the .mbd format?

 

[lennyl]

I have not seen your previous message regarding printing with .mde files but I assume you do not want to immediately print to the default printer?
Have you tried using (DoCmd.RunCommand acCmdPrint)? this works perfectly well with .mde files and brings up the standard windows print box which allows the user to choose which printer they would like to send th job to.

If I have got the wrong end of the stick and your problem is something completely different then I apologise in advance. Best of luck

Lenny

 

[number2]

.MDE format can not SVAE printer setups. Each time use bring up the print dialog you need to setup a specific priinter. It will not save the printer/page setup.