Disable Shift Key, F11 Etc..

Hi,

I am just about to set up user level security for my database. Before I do, how do I disable the holding the shift key thing when opening a database to get into the database window?

I want to make it so the users can't see the database window or access the backend data. As I will need to give permissions to use most of the tables, how is this done?

I am using Version: 2002 (10.0) XP

Any help would be much appreciated.

Thanks



ADVERTISEMENT

Disable The [Shift] Key

I need to disable the [Shift] key so that when the users open my MS Access database, they cannot by pass the open form and display the database window.

We had code that worked correctly with an MS Access 2000 MDB, and even works with an MS Access 2003 ADP, but the same code is ignored by MS Access 2003 MDB.

We add Module named "DisableByPassKey", here is the code...

Public Function SetProperties(strPropName As String, varPropType As Variant, varPropValue As Variant) As Integer
On Error GoTo Err_SetProperties

Dim prps As AccessObjectProperties
Dim prp As AccessObjectProperty
Dim isPresent As Boolean


Set prps = Application.CurrentProject.Properties
For Each prp In prps
If (StrComp(prp.Name, strPropName, vbTextCompare) = 0) Then
isPresent = True
Exit For
End If
Next

If (isPresent) Then
prps(strPropName).Value = varPropValue
Else
prps.Add strPropName, varPropValue
End If

Exit_SetProperties:
Exit Function

Err_SetProperties:
If Err = 3270 Then 'Property not found
Properties.Append prp
Resume Next
Else
SetProperties = False
MsgBox "Runtime Error # " & Err.Number & vbCrLf & vbLf & Err.Description
Resume Exit_SetProperties
End If

End Function

The code does not cause an error, it just seems to do nothing. When I set the [Shift] key to "disabled", then re-open the database, the [Shift] key works once again.

If you have any ideas, it would be great.

Thank you!

View Replies View Related

Disable Shift Key On Load

Ok, I'm new the access database security. I want to disable the shift key
as soon as the database is opened to prevent users from getting to my data. I
do have userlevel security in place with modal forms. This is my final step...I
hope.

Is there any code or sample database that I may download? Thank you for your
advice.

Best Regards,

dmac

View Replies View Related

Disable Shift On Open - Version: 2003 (11.0)

How do I prevent a user from using the shift hotkey function to bypass the startup database options?

View Replies View Related

Disable Shift Key On Access 2.0 Startup - Version: 2.0 (not 2000)

Is it possible to disable the shift key on database (Access 2.0) startup so users cannot get to the database window? I've noticed several references to doing this in later versions of Access, but no mention for Access 2.0.

Second question: Where can one go to get advanced programming instruction in MS Access?

View Replies View Related

MDE/Shift Key

I've written a database for a handful of users in my office, split it and compiled the mde, which they are using fine with no problems *touches wood* so far.
This is the first time I've compiled a database into an mde, and I've just noticed that if you hold down Shift when opening the mde, it opens up the database window, showing the forms, queries, reports and macros. The tables are shown as linked, and you can't get into Design view on the Forms and Reports.
I doubt that any of my users are savvy enough to have figured this out, but even so, I was wondering what would happen if someone got in and started changing things?

View Replies View Related

Shift Key

I have a question about security. I have a database. I want all users to have access to edit or delete data via the forms. What I want to prevent is the user just holding shift and editing the tables directly. I really don't want the users to have to log in or use a password, they already have to log on to a secure network. I was wondering if there is a way to just prevent, or password protect, opening a table directly. I still want them to be able to edint table data, I just want to make sure they go through the form to do it. Thanks for your time.

View Replies View Related

Shift Between Two Forms

I've a form "data-order" and a button which opens a new form "specific data" passing a value with openargs.
I just want to insert data in the second form, minimize it clicking on the "hide" button, insert other data in the first form (eventually re-open the second form to modify the specific data) and save all in their tables clicking the "save" button of the first form.
Is it possible to hide the second form without losing the inserted data (to re-view and modify it - if necessary) going back to the first form?
Thanks

View Replies View Related

Shift Bypass

Is there a way to change the shift key and use another key on startup?? Security for me isn't a big issue... but I'd still like to protect things from being tampered with. I don't want to use MS security (I use it on other DBs) but its not really approriate on the one I'm developing. Any ideas??

View Replies View Related

Bypass Shift Key

This is just a little alteration to a database that I got from QDS, rather than type in the full path to the database you can now select it via the windows file selection boxes.

Database is an Access2000 database.

Cheers QDS.

ih.

View Replies View Related

Shift Rota/Calendar

Hi All,

Just wondering if anyone as delt with creating shift calendars(rota). I had an idea to create a calendar simular looking to the outlook design, but wondered if there were any other ideas out there.

To give you info, I want to create a rota so each shift can see what days they are working. There are 5 shift groups and they all work for 6 days before having 4 rest days. In the 6 days they work, the staff work 2 mornings, 2 Afternoons and 2 night shifts. In effect its like a 10 day week instead of (a normal) 7 day week. Of course there will be holidays, sick's and overtime so the rota needs to be flexible to change each persons shift pattern.

I've seen many calendar programs on the forum, but been unsure how these forms work and so wouldn't know where to start for me to adapt them to my needs.

Any ideas will be much appreciated.

Deckspin74 :confused:

View Replies View Related

Opening Db By Holding Down Shift Key

Hello,

Believe it or not, we just upgraded from Access 2000 to 2003. In Access 2000, I have my dbs set up so that you must hold the shift key down while opening the db in order to see the database window. In 2003, holding down the shift key isn't working. Is there another way to get the database window open (or am I doing something terribly wrong)?

Thanks in advance.

View Replies View Related

Password On Opening With [SHIFT]

Question.
Our db is protected, in other words, when an user opens the db, no possibility to open any menu is availiable. However, if the user is smart (some are :D) then opening the db with the [SHIFT]-key held down the db opens and those users can edit the tables etc.

It would be just enough for our situation to have the possibility to set a password to the [SHIFT]-key when opening the db.

Is it possible? and if it is, please explain to me how

Thanks in advance.

View Replies View Related

Shift Design Query

Hello,I am attempting to create a database for a charity organisation, the database will hold information about there volunteers, roles, languages, building, and shifts.One of the main problems I have at the moment is how would I cater for the shifts. Open Sunday - Monday 6 Shifts at present different days are open for different shiftsAny help pointers greatly appriciated.

View Replies View Related

ByPass Shift Key Utility

Here is a utility that will allow you to set the "Shift Key" bypass during startup .... remotely.
Someone has placed an altered version of this here in the archives.
The altered version requires that the machine running the utility must have Common Dialog Library installed and registered.

This version "does not require" the Common Dialog library.
This version is written for Access 97.

The trick here is not to allow other users access to this utility so they can not enable the shift key.

You can copy this utility to a diskette so you can use the utility when not at your local machine.

View Replies View Related

Shift Key - Version: 2002 (10.0) XP

I've got a DB and want to remove the Shift Key bypass. I've gone into Tools - StartUp and unticked 'Use Access Special Keys'. However, I can still use the shift key. Where am I going wrong?

Recall

View Replies View Related

How To Bypass Shift Key And Secure Your Database

I just post this one because it took me more than an hour to find a comfortable solution for access 2003

http://support.microsoft.com/default.aspx?scid=kb;en-us;826765

To set the AllowBypassKey property to False, follow these steps: 1. Start Access.
2. Open an Access database project.
3. In the Database window, point to Macro on the Tools menu, and then click Visual Basic Editor.
4. In the Visual Basic Editor, click Immediate Window on the View menu.
5. Type the following code or paste the following code in the Immediate window, and then press ENTER.CurrentProject.Properties.Add "AllowBypassKey", False


6. Close the Visual Basic Editor, and then close the Access database project.
7. Open the Access database project. Try to bypass the startup options that are set for the Access database project by holding down the SHIFT key while you open the Access database project.

The functionality of the SHIFT key that permits you to bypass the startup option is disabled. Although you hold down the SHIFT key to bypass the startup options, the startup options are executed. You cannot bypass the startup options.

View Replies View Related

Hid Everying Upon Startup: Shift Key Not Working?

Hello,

I hid everything upon startup and holding down shift key isn't working? What am I doing wrong?

Do I hold it down after Logon or before...not sure why it all of a sudden stopped allowing me to bypass.

Please Help.

Thank you.

View Replies View Related

Display Shift Based On Time

I'm making a dispatch call database that will be sorted at the end of the month based on call types and which shift that call was originated on. Our shifts are 6a-2p, 2p-10p, 10p-6a.

I am figuring that the time would be converted to minutes and then the display would be figured based on which times the minutes occured between. IE: the call origintaed at 0100hrs = 60 minutes. It would figure that 60minutes translates to "Night Shift".

How would I convert time into minutes and how would the if/then be established?

Thanks so much for all your help
Dave

View Replies View Related

Re-Enabling A Bypassed Shift-Key - Version: 97 (8.0)

This post serves to provide a method to re-instate the Shift-Key bypass feature when it is disabled with the methods shown here. All the procedures below should be placed in a module, not in the code behind any form.



There are many ways to disable the Shift-Key bypass function in Access. It may also vary by the version of Access. (As I work primarily in Access 97, the functions included in this dissertation have not been tested in other versions.)



TO DISABLE THE SHIFT-KEY:

You need a procedure that will disable the shift-key (you may want to also disable other key functions). . .

Code:Public Function devlock()



10 ChangeProperty "AllowBreakIntoCode", dbBoolean, False ' turn OFF the Break into code feature

20 ChangeProperty "AllowSpecialKeys", dbBoolean, False ' turn OFF the Special Keys feature

30 ChangeProperty "AllowBypassKey", dbBoolean, False ' turn OFF the Shift-Key Bypass feature



End Function

Seeing as "ChangeProperty" is not a native Access function, we will need the code for that as well . . .



CHANGE PROPERTY FUNCTION:

Code:Function ChangeProperty(strPropName As String, varPropType As Variant, varPropValue As Variant) As Integer

Dim dbs As Database, prp As Property

Const conPropNotFoundError = 3270

10 Set dbs = CurrentDb

20 On Error GoTo Change_Err

30 dbs.Properties(strPropName) = varPropValue

40 ChangeProperty = True



Change_Bye:

50 Exit Function



Change_Err:

60 If err = conPropNotFoundError Then ' Property not found.

70 Set prp = dbs.CreateProperty(strPropName, varPropType, varPropValue)

80 dbs.Properties.Append prp

90 Resume Next

100 Else ' Unknown error.

110 ChangeProperty = False

120 Resume Change_Bye

130 End If



End Function

So, to lock your db before distribution, simply enter "devlock" on a new line in the debug window and press enter. When next you open the db, it will be Shift-Key disabled.



However, once the Shift-Key is disabled, you won't be able to get back into design mode unless you provide an unlocking mechanism. Access can be launched from a command line prompt. The easiest way to get to a command line prompt is to click the start button in the lower-left-hand corner of the desktop, then select "Run..." There you see what is called a command prompt.



To launch your app with a command line, use something like this:

"C:Program FilesMicrosoft OfficeOfficeMsaccess.exe" C:DBDirPathNameOfDB.MDB /cmd "secretpassword"



Then, in your app, you need a procedure to check for the password. It is important that the procedure below is one of the first things executed when your app launches. I suggest calling it from an AutoExec macro or in the OnOpen procedure of the first form that loads. And it requires the "ChangeProperty" function above.



Code:Public Function unlockdb()



10 If Command = "secretpassword" Then

20 ChangeProperty "AllowBreakIntoCode", dbBoolean, True ' turn ON the Break into code feature

30 ChangeProperty "AllowSpecialKeys", dbBoolean, True ' turn ON the Special Keys feature

40 ChangeProperty "AllowBypassKey", dbBoolean, True ' turn ON the Shift-Key Bypass feature

50 End If



End Function

Executing a property change does not occur within the current session of the running app. The next time the app is launched, the property change will be instantiated. So you must close and re-open the app for the change to take place.



Now, what if I want to get everyone out of the pool so I can modify the back-end of any given database? For this, I use a simple file-existence method. Every front-end is set up to have the main menu up at all times. In the main menu are two situations that occur;

1) A user cannot close the main menu except by quitting the application with the command button that says "Quit"

2) The main menu has an OnTimer event that checks for the existence of file in the back-end directory every minute. It is this OnTimer event that provides the ability to put all users out of the pool.



The OnTimer event checks the server for a specific file name. (In this case "db1.loc") If that file appears on the server at the location designated in the code, the user is given a message form indicating that they have 2 minutes to save what they are doing before the application closes automatically. Also, as long as the "db1.loc" exists on the server, the app will not launch as the very first routine run by every front-end checks for the existence of that file, and if found, tells the user that db cannot be run until maintenance is complete.



Further, each front-end also checks the version of the distribution copy of the front-end, which is housed on the server. I maintain a "SysInfo" table in each db to hold version and other info. It is always a one record file. When the app launches, after the loc file check routine, the desktop version is checked against the server version and if they do not match, the app closes and another app launches to upgrade the user's version.



Finally, if I need to make a tweak at a user's station, a provision exists for that as well. The title label of the main menu is double-click-able so it will open an inputbox, asking for the Development Password. If the correct password is given, immediately, the tool/menu bars are turned back on, the db window is displayed and the debug window is opened. This does not re-enable the Shift-Key bypass, it merely turns those items on for the current session. When the tweaks are complete, the app is relaunched to re-disable the hidden features.



To add/remove line numbers in code, I use another of Leban's cool tools: Code Comment Builder Wizard (Access 97) or Line Numbers (Access 2000)

View Replies View Related

Block Shift Button When Starting Up Application

Hi, in some application I have made using a switchboard after starting up, I saw that when the user holds the shift button, this switchboard does not show up automatically. How can i fix it that the user cannot interfere holding this button?

View Replies View Related

Improved .. ByPass Shift Key Utility For Access 97

I have finally found time to alter the original version of this Utility to include the ability to handle databases with Database Level Passwords.



There are many other tweaks I made in this utility ..... If you should find a problem .. please PM me with details.



Ricky



This version is for Access 97.



This utility will allow you to set the "Shift Key" bypass property during startup .... remotely.

Someone has placed an altered version of this here in the archives.

The altered version requires that the machine running the utility must have Common Dialog Library installed and registered.



This version "does not require" the Common Dialog library.



The trick here is not to allow other users access to this utility so they can not enable the shift key.



You can copy this utility to a diskette so you can use the utility when not at your local machine.



............ "Special Thanks" goes to ghudson for the help with this updated version.

View Replies View Related

How Do I Get Shift+F9 Results With A Button - Version: 2002 (10.0) XP

I am trying to have a form requery when I add information. My form frmMain has a few subforms, and the frmMain is bound to query qryMain which has a few summed fields. When I try to run any macro to requery, it does not update the sums or the subforms, or I can only get it to do the subform. But if I click on the Primary Key textbox and press Shift+F9, it updates the summed fields and the subforms. I want to create a button control to do what Shift+F9 does, but I cannot seem to figure it out. Any thoughts? Thanks!

View Replies View Related

Shift Key Bypass Utility - Version: 2002 (10.0) XP

Hi

I have just downloaded the shift key bypass utility by R Hicks,

Great bit of kit , thanks,

One question though does it have to be kept on the same drive/computer as the database it is utilised on?

Regards

Darren

View Replies View Related

Shift Patterns In MS Access - Version: 2000 (9.0)

Hi,

I wonder if someone could point me in the right direction with this one....

I need to be able to check at any time which person is working a shift on a specific day, and whether they are working a day or night shift. In effect I have 4 engineers, who work on shifts A B C & D. All the engineers work a 4 on, 4 off shift pattern, so for example if engineer A is working day shift, engineer B will be working nightshift, C & D will be on rest days. The pattern rotates every 4 days, so in the case of engineer A:

1st - days
2nd - days
3rd - days
4th - days
5th - rest
6th - rest
7th - rest
8th - rest
9th - nights
10th - nights
11th - nights
12th - nights
...................and so on.

I need to be able to pull up a form that tells me which engineer is working which shift on a selected date -Ii hope I've explained myself properly. Can this be calculated 'on the fly' using VBA & a reference table or lookup? I'd prefer to do this by programming if possible.

Hope that someone can help.

Many thanks,

Mark Lees

View Replies View Related

Changing Shift Key Access To The DB - Version: 2003 (11.0)

Is it possible to change the key that allows entry to the database to something besides shift? I have the tool that disables shift, but would like to keep a "back door" entry method for myself. Suggestions?

View Replies View Related

Error Message When Opening W/ Shift Key - Version: 97 (8.0)

I am getting this error, what does it mean.

"Operation invalid without a current index"

View Replies View Related

By Passing The Shift Key Function - Version: 2000 (9.0)

Good day UA,

Can someone please give the function/code on how to disable the shiftkey..

Many thanks once again.

View Replies View Related

Shift Key Equivalent After DB Is Opened - Version: 2003 (11.0)

By default, I have a startup form specified and turn off Display Database Window, Display Status Bar and Allow Full Menus.

For some individuals, I would like to turn these features back on without them having to start with the Shift key pressed.

Is there a way to reactivate these features in code?

Jack

View Replies View Related

Access 2007 - Disabling Shift Key And Hiding DB Window

Hi,

I have a couple of databases set up with shift key bypass and DB window hide and a couple of menu bar commands hidden (All code taken from this great forum :) ). Recently my company decided to upgrade Access 2000 to Access 2007 and they have given me a test environment and a time frame to convert / test all my applications.
I found this concept of ribbon and office links very different and shocking.
Is there a way of hidding somethings that you can do with the office links (like compact and repair) and a way of hiding some clusters in the ribbon (like export and import data, have a dtaasheet view of any form? etc) Any help or link along these lines would be helpful..
Thanks,
Priya

View Replies View Related

Calculating Shift Patterns/rosters In Access 2000

Hi,

I wonder if someone could point me in the right direction with this one....

I need to be able to check at any time which person is working a shift on a specific day, and whether they are working a day or night shift. In effect I have 4 engineers, who work on shifts A B C & D. All the engineers work a 4 on, 4 off shift pattern, so for example if engineer A is working day shift, engineer B will be working nightshift, C & D will be on rest days. The pattern rotates every 4 days, so in the case of engineer A:

1st - days
2nd - days
3rd - days
4th - days
5th - rest
6th - rest
7th - rest
8th - rest
9th - nights
10th - nights
11th - nights
12th - nights
13th - rest
14th - rest
15th - rest
16th - rest
...................and so on.

I need to be able to pull up a form that tells me which engineer is working which shift on a selected date -I hope I've explained myself properly. Can this be calculated 'on the fly' using VBA & a reference table or lookup? I'd prefer to do this by programming if possible.

Hope that someone can help.

Many thanks,

Mark

View Replies View Related

Bypassing AUTOEXEC Using SHIFT Not Working - Version: 2003 (11.0)

I did not disable it as far as I know. Any way to get back in?

View Replies View Related

Automate Query Date Shift - Version: 2002 (10.0) XP

I am inheriting an access database which generates reports based on a continuously shifting set of date ranges. (Basically a 12 week schedule)

Is there a way to automatically shift the query date ranges by having a VBA code look at the computers clock?

Thanks...oh and if I am in the wrong section of the ACCESS forums please advise.







PosWeyb

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved