Wrox Programmer Forums
|
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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 12th, 2007, 12:31 PM
Authorized User
 
Join Date: Apr 2007
Posts: 65
Thanks: 0
Thanked 0 Times in 0 Posts
Default Security question

Situation:

Creating a db where users are required to log in using a user name and password.

Question:

Is it possible to make the db 'time out' like after a 10 minute interval of inactivity automatically close the db and log the user out?

Is it possible to program the db to post a message to another user who may be trying to log into the db that someone, with the actual user name, is logged into the db and must exit before the other user can log in?

Bryan

 
Old April 13th, 2007, 11:25 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Yes. Yes.

How much coding do you do?

There are a couple methods I can think of to get the system to shut down after inactivity. I am wondering if there is anyone with a more application specific method. The problem is deciding what constitues activity.

As for user security, how are you implementing this? It sounds like you will need to store values on the back end. In a user table, create credentials that is not linked to the front ends, so users can mess with it, and then set a value in the table when a user is logged on. If someone else tries to log in with the same credentials, just check the value, and if set to Yes, for example, prevent login and pop up a message box instead. Pretty simple if you are already doing security. How are you doing security?





mmcdonal
 
Old April 18th, 2007, 11:17 AM
Authorized User
 
Join Date: Apr 2007
Posts: 65
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Well, coding, don't like it but seems like I am having to do a fair amount of it for what I'm trying to make this DB do. I found another member from the UA form who gave me a security DB that he did. I just edited it to add in some things that I want and now am in the process of adding in all my other tables, forms and queries.

 
Old April 18th, 2007, 11:19 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

If you send a copy, I could see how difficult it would be to add the notification and time out feature.



mmcdonal
 
Old April 18th, 2007, 11:20 AM
Authorized User
 
Join Date: Apr 2007
Posts: 65
Thanks: 0
Thanked 0 Times in 0 Posts
Default

How am I to send a copy?

 
Old April 18th, 2007, 11:24 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Click on my name, then click send and email, then when I reply, you will know where to send it.

mmcdonal





Similar Threads
Thread Thread Starter Forum Replies Last Post
Access security question kuznickic Access 2 August 4th, 2008 01:22 PM
Security Question jezywrap ASP.NET 1.0 and 1.1 Professional 4 December 13th, 2006 10:39 AM
Ajax Security Question! evogli Ajax 1 November 2nd, 2006 05:46 AM
Web Services Security Question Wee Bubba .NET Web Services 0 September 15th, 2005 07:54 PM
data base security question TnTandyO Classic ASP Databases 9 February 13th, 2004 02:11 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.