MS DAO library

[Sheba]

I scrolled down and selected Microsoft DAO but got this message: "Name conflicts with existing module, project or library"



I want to prevent the use of SHIFT to by pass startup options in my application. Could someone please advise how I should go about this? i'm using Access 2010

[Sheba]

I went to Module --> Tools --> References.
I scrolled down and selected Microsoft DAO but got this message: "Name conflicts with existing module, project or library"

I want to prevent the use of SHIFT to by pass startup options in my application. Could someone please advise how I should go about this? i'm using Access 2010

[ssanfu]

It is not necessary to set a reference to DAO in A2010. (Unlike A2000 - A2003)

For the shift key question, see:
http://www.utteraccess.com/forum/lof.../t1986220.html
http://www.databasedev.co.uk/disable_shift_bypass.html


Or Google: "bypass shift key access 2010"

[Sheba]

Hi Ssanfu, I'd seen the info in http://www.databasedev.co.uk/disable_shift_bypass.html previously and it suggests setting a reference to DAO. Could you clarify this please?

"...When you are viewing a Module, click the Tools menu » References. Browse for Microsoft DAO 3.6Select "Files of type: Executable Files (*.exe; *.dll)"
C:\Program Files\Common Files\Microsoft Shared\DAO)..."

[ssanfu]

it suggests setting a reference to DAO.

It is not necessary to set a reference to the DAO library in A2007/A2010. The reference to DAO is set as a default.
Don't worry about setting the DAO reference.


-----------------
In Access 2000 to 2003, to use DAO you needed to set a reference to the DAO Library

Starting with Access 2007 (12.0) and continuing in Access 2010 (14.0) there is a new Access Database Engine (ACE) that replaces the older JET database engine.
DAO is now built into ACE.
By default Access sets a reference to this new object library called Microsoft Office 12.0 Access database engine Object Library.

[Sheba]

Thank you ssanfu for that. I'll use the anti By-Pass code. Hopefully it'll work for me otherwise I'll hola

[Sheba]

hey ssanfu, could you help me out here please? I followed the instructions at this link: http://www.databasedev.co.uk/disable_shift_bypass.html but it is not working. The SHIFT key still activates the navigation bar and menus

I created a public module & added the anti By Pass code to an Image on the Login form

[ssanfu]

I'll try and make some time tonight to look at it.........

[ssanfu]

This was kinda fun... never tried the code before.

I set the password to: Sheba9

WARNING: the PW is NOT case sensitive. This can be good or bad, depending on your requirements.

[Sheba]

Hi thanks Steve but the idea is to prevent a By Pass.

There was no Login prompt for me to use Sheba9 (like you said) and the anti ByPass didn't work. Not sure what you did

[ssanfu]

Double click on the first label.
Enter a wrong password. (or no password or Cancel)
Close Access.
Open the file again, holding the shift key down.
Shouldn't be able to get to the database window...

Double click on the first label.
Enter the right password.
Close Access.
Open the file again, holding the shift key down.
Should be able to have full access to the design mode.

[Sheba]

H'llo Steve, just seen your update on this thread. When I open Access first and then press the SHIFT key before double clicking on the file name, the startup options are bypassed. Will I ever get this right?

[ssanfu]

The shift key option doesn't automagically re-lock itself after you "unlock" it.

If the shift key is able bypass the startup options, double click on the LABEL "Enter Slot Number" then enter a wrong password.
Close the dB, open using the shift key - should not bypass

Double click on the LABEL "Enter Slot Number", then enter the correct password
close the db, open using the shift key - should allow bypass

close the database, then open it
Try the shift key - should allow bypass

Double click on the LABEL "Enter Slot Number" then enter a wrong password.
Close the dB, open using the shift key - should not bypass

I've tried this over and over - always works......

[Sheba]

okay I'll try again after some rest!

[Sheba]

sigh! okay so I adapted the code to my application and the anti BYpass code works. However even though I put the correct password (after double clicking a label), SHIFT key still doesn't work