 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / July 2005Logins and mdw file
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 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...  SignatureRick 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 > Access 97 > I have three Access programs (MDE) running on a variety of PC's [quoted text clipped - 19 lines] > Cheers, > WSF Thanks Rick, I will do the study. Appreciated. WSF > FIRST, your files are not secured. If you can get in without a login, then > there is NO security on your databse. [quoted text clipped - 12 lines] > > Read and re-read the links below... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.