Board index » delphi » BDE can bypass MS Access security

freem...@macau.ctm.net

Delphi Developer
Sat, 28 Oct 2000 03:00:00 GMT

BDE can bypass MS Access security

I'm trying to connect to an Access database with delphi 3. The DB was
created with access 95 and is protected by user-level security in
access. In particular, I've set the password for "Admin" and created
another account called "kent". Everything works fine in Access. But
in database explorer, when I try to open the alias, it will succeed
only when the user name is "Admin" and the password is empty (no other
user name & password combination works). Note that I've set a non-empty
password in Access for "Admin". After the alias is open, I can access
the tables as if I were really logged in as "Admin". How could this be
happening? What does the BDE do to bypass Access' security? How could
I avoid this?

TIA!

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/   Now offering spam-free web-based newsreading

 
Brian Bushay Tea

Delphi Developer
Sun, 29 Oct 2000 03:00:00 GMT

Re:BDE can bypass MS Access security


Quote
>I'm trying to connect to an Access database with delphi 3. The DB was
>created with access 95 and is protected by user-level security in
>access. In particular, I've set the password for "Admin" and created
>another account called "kent". Everything works fine in Access. But
>in database explorer, when I try to open the alias, it will succeed
>only when the user name is "Admin" and the password is empty (no other
>user name & password combination works)

I belive you need the Delphi 3.01 update and BDE 4.51 to use password protected
tables in Access

--
Brian Bushay (TeamB)
Bbus...@DataGuidance.com

Gustavo A. Baratt

Delphi Developer
Sun, 29 Oct 2000 03:00:00 GMT

Re:BDE can bypass MS Access security


Hello,
 you may create a DATABASE component in the form (or in DATA MODULE) an set
the LOGIN PROMPT property to FALSE!!
If does not  work e-mail me

Gustavo Baratto
esta...@npd.ufes.br
NPD - UFES

freem...@macau.ctm.net escreveu na mensagem
<6j93nb$e9...@nnrp1.dejanews.com>...

Quote
>I'm trying to connect to an Access database with delphi 3. The DB was
>created with access 95 and is protected by user-level security in
>access. In particular, I've set the password for "Admin" and created
>another account called "kent". Everything works fine in Access. But
>in database explorer, when I try to open the alias, it will succeed
>only when the user name is "Admin" and the password is empty (no other
>user name & password combination works). Note that I've set a non-empty
>password in Access for "Admin". After the alias is open, I can access
>the tables as if I were really logged in as "Admin". How could this be
>happening? What does the BDE do to bypass Access' security? How could
>I avoid this?

>TIA!

>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/   Now offering spam-free web-based newsreading

Other Threads

1. Bypass BDE for MS Access?

2. MS ACCESS and BDE Security

3. Can anyone recommend a Delphi MS SQL Server toolkit to bypass BDE

4. access to MS ACCESS / MS SQL without BDE?

5. Use MS ACCESS 97 BDE drivers for MS ACCESS 2000

6. Bypass outlook security

7. how to remove the security check for MS access when call the table

8. MS Access and security

9. MS Access 97 - security and user rights

10. MS-Access 97 security problem