473,320 Members | 1,916 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Security question, read only db with subsequent logons

I'm trying to finish implementing security on my database. I have
secured the .mdb with a .mdw file as per the MS security FAQ with no
problems.

The last part of security that I need to implement is that the first
person to open and log on to the database gets to use the database.
Any subsequent log on users will flip into READ-ONLY mode and won't be
able to modify any data.

All my users belong to a 'full-data-access' group that allows them
enough priv's to run the application. I already have VBE code that
inserts a CURRENT_LOGON record when the Switchboard is opened. This
record is deleted when that user exits the system.

I need some code to perform the following logic:
IF anybody_else_logged_in = true
set database to read-only
(maybe revoke full-data-access group and
grant read-only-access group) to this user
else
insert logged_on record into current_logon table
open switchboard
end

TIA
Paul
Nov 12 '05 #1
4 1958
I'm too curious to answer the WHY before I answer the HOW on this one

Pieter

"Paul Malcomson" <pm**********@hotmail.com> wrote in message
news:23**************************@posting.google.c om...
I'm trying to finish implementing security on my database. I have
secured the .mdb with a .mdw file as per the MS security FAQ with no
problems.

The last part of security that I need to implement is that the first
person to open and log on to the database gets to use the database.
Any subsequent log on users will flip into READ-ONLY mode and won't be
able to modify any data.

All my users belong to a 'full-data-access' group that allows them
enough priv's to run the application. I already have VBE code that
inserts a CURRENT_LOGON record when the Switchboard is opened. This
record is deleted when that user exits the system.

I need some code to perform the following logic:
IF anybody_else_logged_in = true
set database to read-only
(maybe revoke full-data-access group and
grant read-only-access group) to this user
else
insert logged_on record into current_logon table
open switchboard
end

TIA
Paul

Nov 12 '05 #2
Paul Malcomson wrote:
I'm trying to finish implementing security on my database. I have
secured the .mdb with a .mdw file as per the MS security FAQ with no
problems.

The last part of security that I need to implement is that the first
person to open and log on to the database gets to use the database.
Any subsequent log on users will flip into READ-ONLY mode and won't be
able to modify any data.

All my users belong to a 'full-data-access' group that allows them
enough priv's to run the application. I already have VBE code that
inserts a CURRENT_LOGON record when the Switchboard is opened. This
record is deleted when that user exits the system.

I need some code to perform the following logic:
IF anybody_else_logged_in = true
set database to read-only
(maybe revoke full-data-access group and
grant read-only-access group) to this user
else
insert logged_on record into current_logon table
open switchboard
end

TIA
Paul


Here is a consideration. There is a program called LDBView for A97 that
lets you know who is logged on to the app. I believe in the newer
Access versions there is a method to determine how many people are
logged on. Goto http://groups.google.com, advanced search, group
*Access* and search for info on LDBView and the newer method.

Now you can determine when there is one user vs many users in the system.

You could then create a global variable when the person logs on that
contains the value of acFormEdit or acFormReadOnly datamode.

Now search through the entire app that has a Docmd.OpenForm and put in
the variable for the value of the datamode.

You may have to make an adjustment if you open a form in acFormAdd datamode.

Remember too that variables lose their value if a person goes into debug
mode.

I just noticed you are a master crossposter. Why do you cross post?

Nov 12 '05 #3
I once had that code on a website,
now it's gone..
and the sourcecode with my laptop when it was stolen..
I have been able to reconstruct most of the code, so if anybody wants it on
their site I'll be happy to send it...
I seem to remember a dutch site who still "sport" a version of the code
(which I "stole" from vb advisor anyhow)
Dev would never allow me to put it into the access web anyhow...

--
Pieter Wijnen

When all else fail try:
http://www.mvps.org/access
http://www.granite.ab.ca
http://allenbrowne.com/

"Salad" <oi*@vinegar.com> wrote in message
news:Ko****************@newsread2.news.pas.earthli nk.net...
Paul Malcomson wrote:
I'm trying to finish implementing security on my database. I have
secured the .mdb with a .mdw file as per the MS security FAQ with no
problems.

The last part of security that I need to implement is that the first
person to open and log on to the database gets to use the database.
Any subsequent log on users will flip into READ-ONLY mode and won't be
able to modify any data.

All my users belong to a 'full-data-access' group that allows them
enough priv's to run the application. I already have VBE code that
inserts a CURRENT_LOGON record when the Switchboard is opened. This
record is deleted when that user exits the system.

I need some code to perform the following logic:
IF anybody_else_logged_in = true
set database to read-only
(maybe revoke full-data-access group and
grant read-only-access group) to this user
else
insert logged_on record into current_logon table
open switchboard
end

TIA
Paul
Here is a consideration. There is a program called LDBView for A97 that
lets you know who is logged on to the app. I believe in the newer
Access versions there is a method to determine how many people are
logged on. Goto http://groups.google.com, advanced search, group
*Access* and search for info on LDBView and the newer method.

Now you can determine when there is one user vs many users in the system.

You could then create a global variable when the person logs on that
contains the value of acFormEdit or acFormReadOnly datamode.

Now search through the entire app that has a Docmd.OpenForm and put in
the variable for the value of the datamode.

You may have to make an adjustment if you open a form in acFormAdd

datamode.
Remember too that variables lose their value if a person goes into debug
mode.

I just noticed you are a master crossposter. Why do you cross post?

Nov 12 '05 #4
but what happens if there's a network error and the CURRENT_LOGON
record is not cleaned up

same problem with the LDB, unless you try to delete it first
actually if there's an LDB, and it can't be deleted, then you have
someone logged in

since you're using the standard switchboard item, just change the
switchboard open code based on the LDB's presence

pm**********@hotmail.com (Paul Malcomson) wrote in message news:<23**************************@posting.google. com>...
I'm trying to finish implementing security on my database. I have
secured the .mdb with a .mdw file as per the MS security FAQ with no
problems.

The last part of security that I need to implement is that the first
person to open and log on to the database gets to use the database.
Any subsequent log on users will flip into READ-ONLY mode and won't be
able to modify any data.

All my users belong to a 'full-data-access' group that allows them
enough priv's to run the application. I already have VBE code that
inserts a CURRENT_LOGON record when the Switchboard is opened. This
record is deleted when that user exits the system.

I need some code to perform the following logic:
IF anybody_else_logged_in = true
set database to read-only
(maybe revoke full-data-access group and
grant read-only-access group) to this user
else
insert logged_on record into current_logon table
open switchboard
end

TIA
Paul

Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

22
by: Alistair | last post by:
hello again oh knowledgable ones Today I took the plunge (more like a hell-hole dive) and upgraded to windows XP Pro.. and as I expected things are slightly different... what I didn't...
4
by: Mike MacSween | last post by:
Yes, I've downloaded and read the white paper (though some time ago). I was considering an alternative to the built-in Access security. Having more than one FE file. For instance there are a few...
4
by: Paul Malcomson | last post by:
I'm trying to finish implementing security on my database. I have secured the .mdb with a .mdw file as per the MS security FAQ with no problems. The last part of security that I need to...
6
by: Shawn | last post by:
Hi. I already have a datagrid where I'm using paging. I have a stored procedure that fills a temp table with 200-500 rows and then sends back 10 records at the time. When I go to page 2 the SP...
3
by: William Gill | last post by:
This is a PHP question that came up while working with SquirrelMail. I read an installation procedure that suggested moving several directories out of web space. Two of them make sense, but the...
6
by: David++ | last post by:
Hi folks, So I have implemented a Web service which provides several Web Methods. Before the client can use the WebMethods they must first be authenticated and authorized i.e. they login, obtain...
6
by: kath | last post by:
Hi all, Platform: winxp Version: Python 2.3 I have a task of reading files in a folder and creating an one excel file with sheets, one sheet per file, with sheet named...
2
by: =?Utf-8?B?bXVzb3NkZXY=?= | last post by:
Hi I have a web app that we use internally, which is accssible internally on a specific port on the server. Our firewall blocks it to outsiders. However, this app is only for Management use,...
2
by: Ken Fine | last post by:
I want to add the security question and answer security feature to the ChangePassword control. I am aware that this functionality is built into the PasswordRecovery tool. I have implemented the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.