Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Posts
    15

    Unanswered: Suppress db level password

    Hello.

    Here's the situation: I have user level security set up with workgroups etc... I also plan on setting up a password on db level to prevent users from copying/importing data. I can't split the db into front - end back end because the front end is copyrighted and users aren't allowed to create their own forms/reports etc... When I tried to set db level password users are asked for it after they log on with their own IDs.

    Question: Is there a way to suppress (but keep) the db level password after users log on with their own IDs?

    Thanks.

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Just a note:

    Don't use DB level password there are many programs on the net, retrieve that password.

    See an example here under:
    http://download.com.com/3000-2092-10...l?tag=lst-0-13

  3. #3
    Join Date
    Feb 2004
    Posts
    15
    Oh, I see. Thanks hammbakka. Then what are other ways of preventing db objects from being exported/copied?

  4. #4
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Originally posted by dbforumer
    Oh, I see. Thanks hammbakka. Then what are other ways of preventing db objects from being exported/copied?
    Using .mde files, enables you that the Reports, Moduls, Forms, Macros not to be edited and changed.

    Using workGroups and .mdw file is your correct option.

  5. #5
    Join Date
    Feb 2004
    Posts
    15
    I tried that. But .mde file still allows the export of the tables with all the data. Any other ideas?

    I wish there was an object (table/form etc...) property that would block it exporting. Those Microsoft egg-heads should've thought of it.
    Last edited by dbforumer; 02-12-04 at 09:10.

Posting Permissions

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