Basically what I want to do is have my database have two password-protected
users: One that can see everything and one that I just show the forms to.
I am having conceptual problems with the whole security scheme + Access
thing.
In an ideal world, I'd like to be able to hand the Access file (by itself)
to the client, plus the two user names & passwords, and have the user in
question be able to open the database in the appropriate view. Sounds
simple enough, but when I crack open the help, it seems that all the
password protection stuff wants this workgroup definition file thing. Isn't
there any way to just set up users with passwords that are saved with the db
itself?
Barring that, I'd like to have the database look for its workgroup file in
the same directory as itself. How would I specify a relative path for the
workgroup file for the "b" option, assuming the "a" option isn't possible?
Re: Pathname to access and usernames in shortcut ... >> network drive (for maintenance reasons initially, ... >> using usernames but no passwords.... change their passwords within the access database (they won't know how ... >> gets the current username from the system and then calls access (via the ... (microsoft.public.access.security)
Re: security issues ... It was obviously never meant to be; multiple defences against it being ... The Ubuntu installer uses a framework called debconf to do ... when you're asking for passwords... you take a lot of care to clean them out of the database... (Ubuntu)
Re: Basic security questions ... > question be able to open the database in the appropriate view. ... > Isn't there any way to just set up users with passwords that are saved ... How would I specify a relative path for the ... The path to the workgroup file is defined in a shortcut in the format: ... (microsoft.public.access.security)
Re: Windows service ... if you know all of this why you recommend to Rotsey not to use Domain Security?... It's easily cracked, doesn't have any metering on it to prevent brute force attacks, transmits the credentials to the database in plain-text, and doesn't integrate at all into the standard security infrastructure already being used by the organization. ... There's no default monitoring of the invalid password attempts, no automatic account lock-out, etc. There's a ton of documentation on this found on the web. ... It's one less set of passwords to remember, less configuration in the long run, fewer plain-text passwords floating around in email & config files. ... (microsoft.public.dotnet.languages.csharp)
Re: Security Problem with Access 2000 ... has the user names, personal ID's, and passwords.... I backed up the database on a CD. ... If you have the report with the user information, then you should be able to open the database with that information. ... Make sure that you're using the correct workgroup file (the wizard normally creates a desktop shortcut; ... (microsoft.public.access.security)
