Results 1 to 4 of 4
  1. #1
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    can't make/design reports/forms. (Access97)

    Just got a call from a friend (a hardware guy with only limited Access knowledge) who is trying to help a client do a quickie Access report in an Access97 database. In database window, however, the New and Design buttons are dimmed for Reports and Forms. Apparently there is no security (no log-in screen). In a newly created database, this was available, just not in the existing database. I have no idea how long this condition has existed; apparently they don't generally do any such maintenance on the database. Any ideas?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  2. #2
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: can't make/design reports/forms. (Access97)

    an MDB or MDE ? I just got stymied by the exact same till i realized it was an MDE

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: can't make/design reports/forms. (Access97)

    The .mdb file doesn't happen to be read-only at the file level (i.e. the read-only flag is set in Windows Explorer), or to have been opened as read-only?

  4. #4
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: can't make/design reports/forms. (Access97)

    I bet you are right, it probably is a .mde database! That makes perfect sense in explaining the problems. I'm getting this all 2nd hand, but I think the db was named .mdb; but I remember I once had to rename a .mde to .mdb just to make Word mailmerge work correctly.

    Thanks!
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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