|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
User log inI want to add a user login to my Access 2007 file. Users will have to present a username and password and depending on their what they enter will have certain restrictions on what they can access. I understand that this was a built in functionality in Access 2003 that has been removed in Access 2007. I have also heard that the easiest way to do this is convert my DB to 2003 - add the user security and then convert back to 2007. This DB is not so complicated so I believe this conversion process would probably not break anything. So - 2 questions How do I add user security in 2003? A link to a good tutorial would be great. How do developers approach this in 2007? OH! One more related comment. This can NOT be based upon machine/windows login as several users may us the same machine and despite my insistence that there be a Windows login, that was rejected. Any help here will be appreciated. Thanks in advance Dave You can convert to 2003 and leave it in that format. 2007 can use it fine.
Security FAQ http://support.microsoft.com/?id=207793 Security Whitepaper http://support.microsoft.com/?id=148555 Although the whitepaper is old, it contains information to help you understand security. I've also outlined the detailed steps at www.jmwild.com/AccessSecurity.htm Regarding your last comment, I assume the Windows login might have been rejected because folks didn't want to have to login/out all the time. What makes you think that they won't just login with one user's name and leave it for everyone to use? -- Show quoteHide quoteJoan Wild Microsoft Access MVP "Dave" <dave@accessdatapros> wrote in message news:BE7986E8-B63C-4C61-8D7F-9C6CC26165FA@microsoft.com... > Access 2007 > > I want to add a user login to my Access 2007 file. > Users will have to present a username and password and depending on their > what they enter will have certain restrictions on what they can access. > > I understand that this was a built in functionality in Access 2003 that > has been removed in Access 2007. > > I have also heard that the easiest way to do this is convert my DB to > 2003 - add the user security and then convert back to 2007. > > This DB is not so complicated so I believe this conversion process would > probably not break anything. > > So - 2 questions > > How do I add user security in 2003? A link to a good tutorial would be > great. > > > How do developers approach this in 2007? > > OH! One more related comment. This can NOT be based upon machine/windows > login as several users may us the same machine and despite my insistence > that there be a Windows login, that was rejected. > > Any help here will be appreciated. > > Thanks in advance > > > Dave Joan,
That's for the detailed steps. I will look it over Dave PS: You are right about leaving the application open. Is there any way to code a "Timeout"? Show quoteHide quote "Joan Wild" <jwild@nospamtyenet.com> wrote in message news:uyWKumWVJHA.5160@TK2MSFTNGP04.phx.gbl... > You can convert to 2003 and leave it in that format. 2007 can use it > fine. > > Security FAQ > http://support.microsoft.com/?id=207793 > > Security Whitepaper > http://support.microsoft.com/?id=148555 > > Although the whitepaper is old, it contains information to help you > understand security. > > I've also outlined the detailed steps at > www.jmwild.com/AccessSecurity.htm > > Regarding your last comment, I assume the Windows login might have been > rejected because folks didn't want to have to login/out all the time. > What makes you think that they won't just login with one user's name and > leave it for everyone to use? > > -- > Joan Wild > Microsoft Access MVP > "Dave" <dave@accessdatapros> wrote in message > news:BE7986E8-B63C-4C61-8D7F-9C6CC26165FA@microsoft.com... >> Access 2007 >> >> I want to add a user login to my Access 2007 file. >> Users will have to present a username and password and depending on their >> what they enter will have certain restrictions on what they can access. >> >> I understand that this was a built in functionality in Access 2003 that >> has been removed in Access 2007. >> >> I have also heard that the easiest way to do this is convert my DB to >> 2003 - add the user security and then convert back to 2007. >> >> This DB is not so complicated so I believe this conversion process would >> probably not break anything. >> >> So - 2 questions >> >> How do I add user security in 2003? A link to a good tutorial would be >> great. >> >> >> How do developers approach this in 2007? >> >> OH! One more related comment. This can NOT be based upon machine/windows >> login as several users may us the same machine and despite my insistence >> that there be a Windows login, that was rejected. >> >> Any help here will be appreciated. >> >> Thanks in advance >> >> >> Dave >
http://support.microsoft.com/kb/210297
Don't worry that it says Access 2000: it works in all versions. -- Show quoteHide quoteDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Dave" <dave@accessdatapros> wrote in message news:DFA32E38-595E-4061-BE72-FF3CDDE0EE1A@microsoft.com... > Joan, > That's for the detailed steps. > > I will look it over > > Dave > > PS: You are right about leaving the application open. > Is there any way to code a "Timeout"? > > > > "Joan Wild" <jwild@nospamtyenet.com> wrote in message > news:uyWKumWVJHA.5160@TK2MSFTNGP04.phx.gbl... >> You can convert to 2003 and leave it in that format. 2007 can use it >> fine. >> >> Security FAQ >> http://support.microsoft.com/?id=207793 >> >> Security Whitepaper >> http://support.microsoft.com/?id=148555 >> >> Although the whitepaper is old, it contains information to help you >> understand security. >> >> I've also outlined the detailed steps at >> www.jmwild.com/AccessSecurity.htm >> >> Regarding your last comment, I assume the Windows login might have been >> rejected because folks didn't want to have to login/out all the time. >> What makes you think that they won't just login with one user's name and >> leave it for everyone to use? >> >> -- >> Joan Wild >> Microsoft Access MVP >> "Dave" <dave@accessdatapros> wrote in message >> news:BE7986E8-B63C-4C61-8D7F-9C6CC26165FA@microsoft.com... >>> Access 2007 >>> >>> I want to add a user login to my Access 2007 file. >>> Users will have to present a username and password and depending on >>> their what they enter will have certain restrictions on what they can >>> access. >>> >>> I understand that this was a built in functionality in Access 2003 that >>> has been removed in Access 2007. >>> >>> I have also heard that the easiest way to do this is convert my DB to >>> 2003 - add the user security and then convert back to 2007. >>> >>> This DB is not so complicated so I believe this conversion process would >>> probably not break anything. >>> >>> So - 2 questions >>> >>> How do I add user security in 2003? A link to a good tutorial would be >>> great. >>> >>> >>> How do developers approach this in 2007? >>> >>> OH! One more related comment. This can NOT be based upon machine/windows >>> login as several users may us the same machine and despite my insistence >>> that there be a Windows login, that was rejected. >>> >>> Any help here will be appreciated. >>> >>> Thanks in advance >>> >>> >>> Dave >> >PS: You are right about leaving the application open. We have a free tool to help shut down applications after a period of>Is there any way to code a "Timeout"? inactivity: Inactive Shut Down Control: http://www.peterssoftware.com/isd.htm Hope this helps, Peter De Baets http://www.peterssoftware.com There are many alternatives to using Access Security when it comes to
securing your database. A shareware version of a simplified user security add-in that I've written - LASsie (Light Application Security) for MS Access - is available for download here: http://www.peterssoftware.com/las.htm Also, there's the Access Project Security Manager from databasecreations, Inc.: http://www.databasecreations.com/prod_apsm.htm Hope this helps, Peter De Baets Peter's Software - Microsoft Access Tools for Developers http://www.peterssoftware.com Peter,
I am going to look at your software solution. I want to make sure I understand the pricing. The will be for a single application in a multi-user enfironment. Would that be a "Single Application License"? Also does this install to "A" computer or to "THE" application From you site "instructions on the screen to install this application on your computer" How difficult to configure? Thanks dave <pdd***@gmail.com> wrote in message Show quoteHide quote news:7ed3778b-fdba-43bf-a14d-726e9e6012c8@p2g2000prn.googlegroups.com... > There are many alternatives to using Access Security when it comes to > securing your database. > > A shareware version of a simplified user security add-in that I've > written - LASsie (Light Application Security) for MS Access - is > available for download here: > http://www.peterssoftware.com/las.htm > > Also, there's the Access Project Security Manager from > databasecreations, Inc.: > http://www.databasecreations.com/prod_apsm.htm > > Hope this helps, > > Peter De Baets > Peter's Software - Microsoft Access Tools for Developers > http://www.peterssoftware.com Dave,
My comments are interspersed below... On Dec 3, 10:11 am, "Dave" <dave@accessdatapros> wrote: Yes.> Peter, > > I am going to look at your software solution. > I want to make sure I understand the pricing. > > The will be for a single application in a multi-user enfironment. > Would that be a "Single Application License"? > It installs to a computer. The shareware/Single Application License> Also does this install to "A" computer or to "THE" application > From you site "instructions on the screen to install this application on > your computer" version of LASsie must be installed on each end-user's computer. We also offer an unlimited, royalty-free distribution license with source code version that does not require additional installations. > Much easier than Access User Security! But it is intended to be a> How difficult to configure? simpler security system. Feel free to try it out. The shareware version can be downloaded at this link http://www.peterssoftware.com/las.zip > Hope this helps,> Thanks > > dave Peter De Baets Peter's Software http://www.peterssoftware.com  
Other interesting topics
I excluded myself from administrators of a db
User Accounts in Access 2007 MDE file security problem First time setting up security Adding a ADDIN in Access 2007 Can't Install Add-In Check if VBA Code is Disabled Re: Unhiding Tools option on Menu Bar Export User list to Excel or similar How does a workgroup file get created? |
|||||||||||||||||||||||
