Re: Logins and mdw file

FIRST, your files are not secured. If you can get in without a login, then
there is NO security on your databse.

Creating userids and passwords in an MDW file DOES NOT secure the file.

You need to make backup copies of your files, then read the security FAQ.
After you have read it (at least once) you should then follow ALL steps IN
ORDER.

SECONDLY, none of this should be done on the SYSTEM.mdw. That is your
default workgroup. Everyone has one of them. You need to create a new
secured workgroup nad store it in the same shared folder as your database
files. This is the workgroup that your files should be tied to. If someone
does not have that file, they should not be able to open your databases.

Read and re-read the links below...

--
Rick B


Security FAQ

http://support.microsoft.com/?id=207793



The Security Whitepaper is also worth reading to help you understand.

http://support.microsoft.com/?id=148555



Joan Wild:

www.jmwild.com/AccessSecurity.htm



Lynn Trapp

http://www.ltcomputerdesigns.com/Security.htm






"WSF" <someone@xxxxxxxxxxxxx> wrote in message
news:yh7ze.13898$U4.1624709@xxxxxxxxxxxxxxxxxx
> Access 97
> I have three Access programs (MDE) running on a variety of PC's
> throughout the office.
>
> In one case all three are running on one PC.
>
> Usually any Access program asks for the Access login and password,
> presumably determined by the joined system.mdw file.
>
> But in this case two of three do require an Access login, but the third
> does not. It merely goes past the login and straight into the opening
form.
>
> I am CurrentUser in parts of the code.
> In the case of this program it seems to log itself on as "Admin" and
> this creates problems.
>
> I have joined to the system.mdw file okay, only to find the "join" has
> disappeared next time I run the MS Access Workgroup Administrator program.
>
> Help please.
>
> Cheers,
> WSF


.

Relevant Pages

  • Re: Linked Table-Embed Password
    ... > for the one login was the security. ... Don't confuse data security issues with data integrity issues. ... It may be common, but it's not secure. ... See http://www.QBuilt.com for all your database needs. ...
    (microsoft.public.access.security)
  • Securing user table with sha function
    ... Now moving on into other aspects of security:P I was thinking of a way to ... secure my login inputs the best way possible. ... Seeing how many different types of injection attacks their is and while ... AND how to secure for injection attacks? ...
    (php.general)
  • Re: How do I protect my login page from prying eyes (forms authentication)?
    ... Sure, do this if you want to, but I'd rather devote time and energy to making my site secure even if someone discovers the "protected" site. ... Once it's out in the open (and if it's believed the contents are high valued, and people suspect that you've hidden the login page as a security measure), you may be *more* likely to be attacked. ... This means that when the site owner prints an invoice, the URL of this page will be shown in the footer. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: How do I protect my login page from prying eyes (forms authentication)?
    ... I suppose I could have the login page in the main site (ie not ... >>At the end of the day though, you're just practicing security through ... Have the secure website generate invoices in the non-secure site, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Ten least secure programs
    ... it's probably better you leave the topic alone ... I said I do not have security issues with the programs I code. ... I didn't realize you were a Linux user, ... > the most widely used and secure UNIX flavors? ...
    (Security-Basics)
Quantcast