Asking for database password

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Mark R
    #1

    Asking for database password

    Hi all,
    This is probably really simple but the answer has eluded me so far. I have a frontend application which when closed on PC's at work, just closes. However, when I close it (an exact copy) on my home PC, the forms & database window close but then prompt for the database password. I can enter the password or click on cancel and then access will shut down. Is there a setting or option I am missing on my home PC? I do not have the same problem with the backend.

    Both machines are running XP pro and access 2000.
    TIA,

    Mark
    Tags: None
    • '69 Camaro
      #2
      Re: Asking for database password

      Hi, Mark.

      Your home computer's "Compact on Close" setting is checked, while the
      computers at work aren't checked. To match the others, open this database
      on your home computer. Open your Tools menu and select Options. Select the
      "General" tab in the Options dialog window. A little further than half-way
      down on the left side is a check box for "Compact on Close." If you uncheck
      this box, then the next time you close the database, it won't compact and
      ask you for the password when the compaction is done.

      HTH.

      Gunny

      See http://www.QBuilt.com for all your database needs.
      See http://www.Access.QBuilt.com for Microsoft Access tips.


      "Mark R" <mark.reed75@nt lworld.com> wrote in message
      news:tQlTc.461$ Ho4.281@newsfe1-gui.ntli.net...
      Hi all,
      This is probably really simple but the answer has eluded me so far. I
      have a frontend application which when closed on PC's at work, just closes.
      However, when I close it (an exact copy) on my home PC, the forms & database
      window close but then prompt for the database password. I can enter the
      password or click on cancel and then access will shut down. Is there a
      setting or option I am missing on my home PC? I do not have the same problem
      with the backend.

      Both machines are running XP pro and access 2000.
      TIA,

      Mark


        Comment

        • Wayne Morgan
          #3
          Re: Asking for database password

          I believe Gunny is correct. If I remember correctly, Access 2000 needed the
          password to reopen the database after a compact. Access 2002 and 2003 don't
          do this.

          --
          Wayne Morgan
          MS Access MVP


          "'69 Camaro" <Black_hole.To. 69Camaro@Spamea ter.org> wrote in message
          news:qIlTc.2996 $io1.187@nwrddc 02.gnilink.net. ..[color=blue]
          > Hi, Mark.
          >
          > Your home computer's "Compact on Close" setting is checked, while the
          > computers at work aren't checked. To match the others, open this database
          > on your home computer. Open your Tools menu and select Options. Select
          > the
          > "General" tab in the Options dialog window. A little further than
          > half-way
          > down on the left side is a check box for "Compact on Close." If you
          > uncheck
          > this box, then the next time you close the database, it won't compact and
          > ask you for the password when the compaction is done.
          >
          > HTH.
          >
          > Gunny[/color]


            Comment

            • Mark R
              #4
              Re: Asking for database password

              Many Thanks
              "Wayne Morgan" <comprev_gothro ughthenewsgroup @hotmail.com> wrote in message news:8NnTc.759$ ol3.403@newssvr 22.news.prodigy .com...
              I believe Gunny is correct. If I remember correctly, Access 2000 needed the
              password to reopen the database after a compact. Access 2002 and 2003 don't
              do this.

              --
              Wayne Morgan
              MS Access MVP


              "'69 Camaro" <Black_hole.To. 69Camaro@Spamea ter.org> wrote in message
              news:qIlTc.2996 $io1.187@nwrddc 02.gnilink.net. ..[color=blue]
              > Hi, Mark.
              >
              > Your home computer's "Compact on Close" setting is checked, while the
              > computers at work aren't checked. To match the others, open this database
              > on your home computer. Open your Tools menu and select Options. Select
              > the
              > "General" tab in the Options dialog window. A little further than
              > half-way
              > down on the left side is a check box for "Compact on Close." If you
              > uncheck
              > this box, then the next time you close the database, it won't compact and
              > ask you for the password when the compaction is done.
              >
              > HTH.
              >
              > Gunny [/color]


                Comment

                • '69 Camaro
                  #5
                  Re: Asking for database password

                  Glad it helped!

                  Gunny

                  See http://www.QBuilt.com for all your database needs.
                  See http://www.Access.QBuilt.com for Microsoft Access tips.


                  "Mark R" <mark.reed75@nt lworld.com> wrote in message
                  news:lPDTc.88$X u.38@newsfe4-gui.ntli.net...
                  Many Thanks
                  "Wayne Morgan" <comprev_gothro ughthenewsgroup @hotmail.com> wrote in
                  message news:8NnTc.759$ ol3.403@newssvr 22.news.prodigy .com...
                  I believe Gunny is correct. If I remember correctly, Access 2000 needed
                  the
                  password to reopen the database after a compact. Access 2002 and 2003
                  don't
                  do this.

                  --
                  Wayne Morgan
                  MS Access MVP


                  "'69 Camaro" <Black_hole.To. 69Camaro@Spamea ter.org> wrote in message
                  news:qIlTc.2996 $io1.187@nwrddc 02.gnilink.net. ..[color=blue]
                  > Hi, Mark.
                  >
                  > Your home computer's "Compact on Close" setting is checked, while the
                  > computers at work aren't checked. To match the others, open this[/color]
                  database[color=blue]
                  > on your home computer. Open your Tools menu and select Options. Select
                  > the
                  > "General" tab in the Options dialog window. A little further than
                  > half-way
                  > down on the left side is a check box for "Compact on Close." If you
                  > uncheck
                  > this box, then the next time you close the database, it won't compact[/color]
                  and[color=blue]
                  > ask you for the password when the compaction is done.
                  >
                  > HTH.
                  >
                  > Gunny[/color]



                    Comment

                    • XMVP
                      #6
                      Re: Asking for database password

                      Ditch the HTML. Send plain text only.
                      "Mark R" <mark.reed75@nt lworld.com> wrote in message news:lPDTc.88$X u.38@newsfe4-gui.ntli.net...
                      Many Thanks
                      "Wayne Morgan" <comprev_gothro ughthenewsgroup @hotmail.com> wrote in message news:8NnTc.759$ ol3.403@newssvr 22.news.prodigy .com...
                      I believe Gunny is correct. If I remember correctly, Access 2000 needed the
                      password to reopen the database after a compact. Access 2002 and 2003 don't
                      do this.

                      --
                      Wayne Morgan
                      MS Access MVP


                      "'69 Camaro" <Black_hole.To. 69Camaro@Spamea ter.org> wrote in message
                      news:qIlTc.2996 $io1.187@nwrddc 02.gnilink.net. ..[color=blue]
                      > Hi, Mark.
                      >
                      > Your home computer's "Compact on Close" setting is checked, while the
                      > computers at work aren't checked. To match the others, open this database
                      > on your home computer. Open your Tools menu and select Options. Select
                      > the
                      > "General" tab in the Options dialog window. A little further than
                      > half-way
                      > down on the left side is a check box for "Compact on Close." If you
                      > uncheck
                      > this box, then the next time you close the database, it won't compact and
                      > ask you for the password when the compaction is done.
                      >
                      > HTH.
                      >
                      > Gunny [/color]


                        Comment

                        Previous template Next
                        Working...