Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2007

    Question Unanswered: HELP WITH MDE Database


    I want to lock down my DB but want the user to have the ability to change the text in a letter that they print out each year. Each year the location and some description changes. This letter is used in a mail out.

    I created a button that they press which opens up the letter (report) and they can then edit, however, after making the DB into an MDE file, they are not able to.

    How can I get around this problem. Please help.

    Thanks guys!

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    smartest soultion to this issue (in my view) would be to use the DB to provide the data to the user as a query that they can use in say Word or some other program

    let the users do what ever the heck they like with the letter..

    that way round you get the finesse of the word processign for the layout & fortmatting and the data form the MDE.

    I seem to remember the 'only' bugbear was using the right placeholders in the word document
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Feb 2004
    One Flump in One Place
    Another alternative (assuming that there are only minor text changes to the report) is to store the text in a table and allow the user to edit this.

    pootle flump
    ur codings are working excelent.

  4. #4
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    I agree with pootle flump. If you're only talking about a few lines changing make up a small table to hold these values, allowing the end user to change them at will. I always have a form in my apps named frmLetterhead. The end user gets to enter their company name, address, phone/fax numbers and URL. Then anytime a document is produced that requires it this data is incorporated in the report. The company can easily change any of this data as it changes. The problem with depending on a document in say, MS Word, is that you're dependent not only on them having and keeping Word on all machines they may use for your app in the future, but on M$ not changing the way Access works with future versions of Word. Just MHO!
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  5. #5
    Join Date
    Jan 2007
    Thanks guys I will try what you advise. I was already thinking about keeping the text in a table and let them alter the table. Maybe that is the way I will go.

    Thank you!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts