I'm sure i'm not the only one who has done this, but please HELP!!!! I have devised a new Access Database and saw online I could disable the Shift Key bypass. So, trying to advance my Access skills, I ran the code in a Module and have now locked my self out of the database. Actually, not locked out. I just can't view my tables, modules, queries and such any more. Below is what I have adjusted:
StartUpShowStatusBar = False
AllowShortcutMenus = False
AllowFullMenus = False
AllowBuiltInToolbars = False
AllowToolbarChanges = False
AllowSpecialKeys = False
UseAppIconForFrmRpt = False
AllowByPassKey = False
QUESTION IS: How do I override this and get back to normal. There must be away. Thanks.
11  19217 
Can u not get into the DB at all?
If u can get in, can u get into the vba code window? If so, change settings to true so u can get it
Alternatively, try this tool
Property Editor
http://www.jamiessoftware.tk/propeditor/pe_jump.html
Yes, I can get into the DB but not into the VB panel. I'll try the tool you sent me and see if it works. Thanks.
NeoPa 32,556
Expert Mod 16PB
If that doesn't work try the following :-
1. Open Access without a db.
2. Alt-F11 to open the VBA window.
3. Go back to Access window and open the database.
Can you now access the code when nothing is executing by clicking on the running VBA button?
Tried that and yes it did allow me to get into the VB panel but of course I password protected the module. On ideas on how to undo my password??? Thanks again.
Its a bit late now however I disable the shift key by using somewhere on one of the pictures displayed, a tiny hidden form that has enable shift and another somewhere else that has disable shift. But I backed up the db before playing with making the changes
I'm sure i'm not the only one who has done this, but please HELP!!!! I have devised a new Access Database and saw online I could disable the Shift Key bypass. So, trying to advance my Access skills, I ran the code in a Module and have now locked my self out of the database. Actually, not locked out. I just can't view my tables, modules, queries and such any more. Below is what I have adjusted:
StartUpShowStatusBar = False
AllowShortcutMenus = False
AllowFullMenus = False
AllowBuiltInToolbars = False
AllowToolbarChanges = False
AllowSpecialKeys = False
UseAppIconForFrmRpt = False
AllowByPassKey = False
QUESTION IS: How do I override this and get back to normal. There must be away. Thanks.
I'm only a newbie myself and I don't know whether you can create a form however if you can create a new form and add a button called enable and then attach to that button
Private Sub Enable_Click()
Dim db As DAO.Database
On Error Resume Next
Dim prp As DAO.Property
Set db = CurrentDb
db.Properties.Delete "AllowBypassKey"
Set prp = db.CreateProperty("AllowBypassKey", dbBoolean, True, True)
db.Properties.Append prp
db.Properties.Refresh
Set prp = Nothing
Set db = Nothing
End Sub
Save and run and click the button.
This switches enables acces via the shift key again
You could try this utility if u wanted to
http://www.jamiessoftware.tk/propeditor/pe_jump.html
it may help
once u are in, u can code bypass
NeoPa 32,556
Expert Mod 16PB
If you make sure the VBA window is open before opening the database, you open it normally then go to the VBA window and, after using Ctrl-G to open the immediate window, execute the following code :- - Call CurrentDB.Properties.Delete("AllowBypassKey")
(nicked from haltonbj above)
This should be enough to allow you to open it next time holding the Shift key to bypass the project starting up.
I believe this depends on the DDL parameter used when creating it originally and your security level.
For more info on that check it out in the help system.
PEB 1,418
Expert 1GB
Do you want to enable your shift bypassing?
You can do it from other database modifying your property of your database! One time it arrived to me... And it works Well My GOD!!!! :)
So See your code for creating the bypass... See the documentation about the used methods and there is a good help :)
IF you can't write the necessary code write to my mail...
:)
Thank you all very much. I have managed to get into the DB now by using the properties tool program as described above. But my problem is now getting into the modules. I have password protected them in VBA and that's what I need help with. I know I can purhcase a $40 VBA password reset tool that will fix my problem, but before doing so, Is there any other way of resetting my password or is there any freeware to fix the problem? Thanks again.............
Hey Guys,
I would like to say thanks very much for this.
** Snip **
Cheers
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Alex Stevens |
last post by:
Hi All,
I'm writing a launcher program which checks for updates and copies them down
to the client.
However, I would like the user to be able to modify the settings for the
launcher. As this...
|
by: PerryC |
last post by:
I have search googles and there are hundreds of tips about
AllowByPassKey... however, none works for me... well, perhaps I am too
new to such high level functionality that it just does not make...
|
by: Ghulam |
last post by:
I am using an Access 2k ADP (Converted into ADE) front end and SQL 2K
on the backend. Although I taught pretty much myself into these
concept with the help of some publications and users group...
|
by: tdmailbox |
last post by:
I set up my code to disable the shift bypass however for certain users
I want to allow them through a button no a form to be able open up the
list of tablies and queries.
Is there a vb command...
|
by: google |
last post by:
I am creating a new database for use within our company, that I'd like
to make reasonably secure (short of a true server based solution). The
back-end of a non-server based database seems to be...
|
by: CanuckChuck |
last post by:
I have a code for enabling a command button to password protect the enabling/disabling of the Shift bypass. For some reason though I keep recieving a syntax error when I try to use it. I copied the...
|
by: elen |
last post by:
hello!
i have the below problem.I have a form wich works fine but my php script doesn't do it's work.Well i'm trying to insert the data from my form to my database(this works,i've tested it).Further...
|
by: SLauren |
last post by:
Hi,
Can anyone please suggest me how to take the back-up of the tables "without data"? Right now i am using Mysql Administrator on Windows XP for taking back-ups and restoring.
TIA......,
Lauren
|
by: ziccardi |
last post by:
hi we have an mde database that was written by an ex-employee. Some update our company made is requiring us to re-link all our database tables, however, I'm assuming that the shift bypass key was...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |
