Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Dec 2001
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Compact/Repair on Exit (A2k, Sr1)

    I have created front/back end databases with the front end on user PC's and the backend on an NT server. Both use database passwords for access (same pw for both). The front end db has the Compact and Repair on Exit set, which it does very nicely, but when the compact is done, it prompts for a password. It seems to make no difference if the password is entered, or the Cancel button clicked, the job exits with no discernable problems. Logging back in afterwards works fine as well.

    Any idea why this password prompt is comming up, or how to get rid of it?

    As I said, it doesn't seem to be causing any problems, its just annoying to the users.

    Thanks,

    Warren

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Compact/Repair on Exit (A2k, Sr1)

    When you use the Compact and Repair on Exit, it closes the database first, does the compact, and then reopens it before actually shutting down. Under normal circumstances you don't see that going on, but when you have a database password set, you have to supply the password so it can reopen the database before closing. We don't normally set a password on the front-end, because the things we want to prevent users from seeing are typically stored in the back-end mdb as data. You still get the password prompt from the back-end when you open the file on start-up, but you don't when you a compact and repair on exit. We also don't usually use the compact and repair on exit for front-ends because we put all the tables in the back-end. The only exception would be if we are creating temporary tables and then deleting them. Hope this gives you some insight as to what is going on.
    Wendell

  3. #3
    New Lounger
    Join Date
    Dec 2001
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compact/Repair on Exit (A2k, Sr1)

    Thanks, that makes sense.

    Unfortunatly, the front end password is necessary due to the nature of the database and federal inspection guidelines, otherwise only the backend would be password protected as you suggest. Also as you stated, there are many temporary tables specific to the front end user, making the compact on exit a viable solution.

    They will have to live with the additional prompt, thanks again.

    Warren

Posting Permissions

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