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??
In Access 2010 I'm setting and unsetting the bypass shift key property - set to true for users and set to false for me, the developer. No problem but what I can't figure out is how do I work out whether it is set or not?
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.
I am able to bypass the shift key so I can disable ribbon and all menus at startup.
But the issue I have is anytime someone makes a copy of the database or it is their first time opening it they get prompted with the security warning:
"Security Warning - some active content has been disabled, click here to enable"
and it gives them complete access to see the back end of the database because while that warning message is popped up ... before they click "enable" they can go do anything in the database including see tables, data, and vba.
Once they click "enable content" that first time the bypass takes effect and the ribbon and all menus disappear, but if they dont click it they can navigate all around the db
I was reading the threads related to bypass issues...
Now I know how to disable (or enable) shift key of a database with password using the code provided by ghudson: http://www.access-programmers.co.uk/forums/showthread.php?t=51479&highlight=bypass
In other thread he provided another way to enable or disable the shift key using another method: (developed by Ricky Hicks):
this one can easily disable or enable the shift key of any database... even if that is disable with the password protected method provided by ghudson...
so... my question... is there any method that will ONLY allow enable or disable the key with a password?
On my form the first control which gets focus has a code which cannot contain a null value. It may happen nevertheless that users may need to just close the form without making an entry in this control (listbox).
Is there a way I can add a code to a cmbbutton to skip that forced entry meaning to leave the control null and exit the form? Thank you.
If I hold down the SHIFT-key and click on my access database the database boots up with the startup options! I can't get into my database even if I hold down the SHIFT key!! Help me, please
I've used this parameter back in Access 2.0 where I ask for I put [What location?] as the parameter and users can put 'North' or hit enter to get all locations.
I know that I can startup MS-Access manually and bypass the startup options, including any macro that is set to run automatically, by holding the Shift key down when launching the application. I have:
Code: Public Sub AccessStuff() Dim myaccess As New Access.Application myaccess.OpenCurrentDatabase(" orfs006slsops_repts\_RS DevSOPSOP.MDB") Dim db = myaccess.CurrentDb() End Sub
which works nicely and opens the database just fine. However, this mdb has a startup macro defined in it. I can't hold down the Shift key since I'm doing this from a program. In this case, how can I bypass the startup macro?
I have a database which is slowly evolving. Users needed a feature to delete some records without a trail and some with a trail from the form. So I added an apply action field in the subform using which they can delete a record without a trail and if they wanted to keep a trail they could do that too. When user selects "Delete Violations as it was entered in error" the system deletes the record completely which is what everyone wanted.
After six months of use now I am asked to add an audit trail. I managed to do that also. I also looked at Browne's method but my data structure does not match the requirements for that method. I used an alternate method. It works as intended except when a record is completely deleted using the code I mentioned above. Then it goes in the infinite loop. I somehow need to bypass the before update event so that the function to write the audit trail is not called.
There is a table with many columns. I want to add many rows to this table. The easiest way is to write a query to do that. But most of the columns have validation criteria, lookup tables, default values, nulls not accepted condition and what not. Where as my new records to be added have only the values in 4 columns and the rest are null. Is there a parameter that can be used to bypass all these controls and add the records? You are going to say "You will destroy the integrity and consistency of the database".
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?
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.
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 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.
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
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.
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)?
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
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.
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.
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?