Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old November 28th, 2010, 09:30 PM
Registered User
 
Join Date: Nov 2010
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default User login and DB security ACCESS 2010

I hve a built A CRM to include contacts calls leads and projects.

I have created user login with password that opens with the DB

1 How do I now create a DB lock out with wrong password info

2 Create a Macro or True false relationship with the user name and password to only allow that use to add and edit their contacts,calls, leads, projects with a read only on all the other information.

My goal will be to split the DB with user login in to a FE when they login they go to a custumized dashboard for that user (this currently happens)

my issue is they can close the login with out entering user or password and gain access to all the forms and they are able to change edit other users entries using the forms and queries even after loging in.

please any help on any of this would be greatly apreciated
Reply With Quote
  #2 (permalink)  
Old November 29th, 2010, 02:30 AM
Friend of Wrox
Points: 1,015, Level: 12
Points: 1,015, Level: 12 Points: 1,015, Level: 12 Points: 1,015, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2010
Posts: 245
Thanks: 5
Thanked 24 Times in 23 Posts
Default

I would split the database ASAP. You will then need to fully test your database to be sure that everything works correctly. Be sure to put eh back end on the server to test performance.

I wrote this article on the subject: Splitting your Access database into application and data

Here is an example of a login is system: Boiler Plate Database

Hope this helps ...
__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015
Reply With Quote
  #3 (permalink)  
Old November 29th, 2010, 02:33 PM
Registered User
 
Join Date: Nov 2010
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default Splitting the BD is not the issue

I need to create the working BD before I Create a FE BE its easier to add items and test .at this point no one is working in the DB other then me.

Any Idea on the user login issue. I know it can be done but how is my issue
Reply With Quote
  #4 (permalink)  
Old November 29th, 2010, 03:17 PM
Friend of Wrox
Points: 1,015, Level: 12
Points: 1,015, Level: 12 Points: 1,015, Level: 12 Points: 1,015, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2010
Posts: 245
Thanks: 5
Thanked 24 Times in 23 Posts
Default

Quote:
Originally Posted by lex8058 View Post
I need to create the working BD before I Create a FE BE its easier to add items and test .at this point no one is working in the DB other then me.
I have to disagree. You can not properly test the database until it is split and the back end is on another machine.

If you know all the things to avoid when designing a split database then you might not having any problems once you split it.

I find just way to many advantage to having a database split from the start.

Quote:
Originally Posted by lex8058 View Post
Any Idea on the user login issue. I know it can be done but how is my issue
Without seeing you database it is really impossible to spot the issue.

Designing a security system is not a easy task to do correctly.

Implementing a security system after a database is completed can be done but it is a lot more difficult. Unless you have already planned for it in your initial design, it often requires some redesigning of objects and work flow to get the security system working properly.

Did you get a chance to look at the example?
Did it give you any ideas?

In what mode are you opening your log on form?
__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015
Reply With Quote
  #5 (permalink)  
Old November 29th, 2010, 03:34 PM
Registered User
 
Join Date: Nov 2010
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default RE: splitting DB now

I did go to your example. It looks good How did you get the login to work.
I created a Employee table with passwordID as my Primary Key. Then linked that to my login form.

The dasboard is good and I may design parts of mine to be more button friendly but currently its a Navigation form.


We may want to create a share point at some time but not yet( I am creating all Macros so that when and if we do we will not have any code issue'

The login, Not sure what you mean by Mode. I created a form Login then put it in the options display form when open after entering user and password the form closes and opens a personal Dashboard.

This is not a fully working DB. I am creating it now (but I may take your advise and copy my DB before I split it )splitting it now is premature in being that I am using 2010 to create it and all of my users do not have Access 2010 so when I split it I will be creating A accbe (not sure that is the correct lettering I will be formating it so that Access 2010 is not needed to use the FE)

Last edited by lex8058; November 29th, 2010 at 04:07 PM..
Reply With Quote
  #6 (permalink)  
Old November 29th, 2010, 04:44 PM
Friend of Wrox
Points: 1,015, Level: 12
Points: 1,015, Level: 12 Points: 1,015, Level: 12 Points: 1,015, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2010
Posts: 245
Thanks: 5
Thanked 24 Times in 23 Posts
Default

Quote:
Originally Posted by lex8058 View Post
I did go to your example. It looks good How did you get the login to work.
I created a Employee table with passwordID as my Primary Key. Then linked that to my login form.

The dasboard is good and I may design parts of mine to be more button friendly but currently its a Navigation form.


We may want to create a share point at some time but not yet( I am creating all Macros so that when and if we do we will not have any code issue'
Ohhh .. trying to do security with just macros.

I have never using just macros. I have always used code modules to make it hard to crack.


Quote:
Originally Posted by lex8058 View Post
The login, Not sure what you mean by Mode. I created a form Login then put it in the options display form when open after entering user and password the form closes and opens a personal Dashboard.
Are you opening your logon form in dialog mode?

You will probaly need to be sure to trun off the control box and close butten etc to try to force the user to click you commnd button.

You will need to also stop alt-F4. You proably will need to use teh autokeuys macro for that.

Quote:
Originally Posted by lex8058 View Post
This is not a fully working DB. I am creating it now (but I may take your advise and copy my DB before I split it )splitting it now is premature in being that I am using 2010 to create it and all of my users do not have Access 2010 so when I split it I will be creating A accbe (not sure that is the correct lettering I will be formating it so that Access 2010 is not needed to use the FE)
Unfortunately ACCESS WILL ALWAYS BE REQUIRED to run your front end (.accdb, accde, accdr). If the users do not have Access installed then you will have to install some version of Access. Either the full retail version or the runtime version.

It sounds like you are probably planning on using the Access Runtime. I deploy ALL my front ends with Access running in runtime mode or with the runtime.

To be able to properly test you database for running as a ACCDE with the Access runtime you really need to split your database and compile the database into an ACCDE. Otherwise you can not properly test. You will also need a machine with the actual runtime installed to be sure that every things works correctly. There are things that work in an ACCDB that will NOT work in an ACCDE or in the actual Access Runtime.

My opinion is that it is NEVER to premature to split your database. Especially if you are deploying a front end as a ACCDE and/or using the runtime.
__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015

Last edited by HiTechCoach; November 29th, 2010 at 06:05 PM..
Reply With Quote
  #7 (permalink)  
Old November 29th, 2010, 05:27 PM
Registered User
 
Join Date: Nov 2010
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default I guess I should use a different term then security

I need to set the user options or defiintions so that one user can not edit or change another users data assigned to them only be able to read.

Thanks for all the help I have alot of good input to apply to my DB.

I am going to search the term Dialog mode, Being fairly new to all this I do not know the term or options. What mode would you suggest I use
Reply With Quote
  #8 (permalink)  
Old November 29th, 2010, 06:01 PM
Friend of Wrox
Points: 1,015, Level: 12
Points: 1,015, Level: 12 Points: 1,015, Level: 12 Points: 1,015, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2010
Posts: 245
Thanks: 5
Thanked 24 Times in 23 Posts
Default

Since you are new to all of this I would urge you to spend some time studying the example database. It will teach you a lot about doing what you want.

Have you looked at the design of the log on form in the example?

Do you have the Sharepoint Enterprise edition required for publishing Access databases?

Curious, have you actually published an Access database to Sharepoint?
__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015
Reply With Quote
  #9 (permalink)  
Old November 29th, 2010, 06:59 PM
Registered User
 
Join Date: Nov 2010
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default I opened it but all the data is locked out

Is there do you have a second admin password to unlock the design?

I like the login design, But I did not see how you placed the form in the load on start. I see you did not got to the options.

No we do not have the software yet. I have to sell the oldtimers on the DB being accessable from our server with FE loaded on our desk tops before they will ever sign off on a web based application.

Id love to check out your example but I can't navigate past the Dashboard to look at the forms design or formulas.
am I missing something?
Reply With Quote
  #10 (permalink)  
Old November 29th, 2010, 07:48 PM
Friend of Wrox
Points: 1,015, Level: 12
Points: 1,015, Level: 12 Points: 1,015, Level: 12 Points: 1,015, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2010
Posts: 245
Thanks: 5
Thanked 24 Times in 23 Posts
Default

Quote:
Originally Posted by lex8058 View Post
Is there do you have a second admin password to unlock the design?

I like the login design, But I did not see how you placed the form in the load on start. I see you did not got to the options.

No we do not have the software yet. I have to sell the oldtimers on the DB being accessable from our server with FE loaded on our desk tops before they will ever sign off on a web based application.

Id love to check out your example but I can't navigate past the Dashboard to look at the forms design or formulas.
am I missing something?
Hold down the shift key while opening the database to bypass the autoexec macro.

To help you better, would you mind sharing your programming skills and background. What is your database design background and experience?
__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
user permission in access 2010?? DivX Access 14 December 10th, 2012 07:23 AM
Using Access 2010 and Access Services with SP 2010 kmaford BOOK: Professional SharePoint 2010 Development 0 September 14th, 2010 04:25 PM
Permissions on DB without user-level security nbourre Access VBA 4 June 7th, 2008 08:09 AM
Chapter 6 Blog - Cannot Login Access DB bmoran007 BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 4 November 26th, 2007 10:53 AM
session login with access db surethg Beginning PHP 3 November 19th, 2004 04:34 PM



All times are GMT -4. The time now is 05:09 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.