I'm trying to programming the database application that is locked with
security.
I set security to MS-Access system file(*.mdw) about user, access
permission, password etc. But when I open that MS-Access file(*.mdb) on
Delphi 4.0 those settings couldn't work.

For example, if I login UserID with KKK and some password, and its
access permission is only able to read file, but when I open that
database file in Delphi, Delphi permit to write some data over that
database.

What should I have to do?
If someone tried this kind of stuff, please share your information to
me.
Thanks in advance.

Sujin Lee from Korea
sin...@geocities.com

Did you point your BDE alias's "System Database" setting to the *.MDW file
which your application uses?  If you do not specify which MDW file the BDE
should use,  it is rather difficult for it to know which one you want it to
use... <g>

Jerry Bloomfield (TeamB)
--
Jerry Bloomfield                                     JersW...@wwa.com
Proud Member of Borland's TeamB
"We'll do anything if you don't pay us."

Are you using the native BDE Access driver or ODBC. I have done a couple of
apps using Access user level security and they seem to work correctly.

Bill

--

Bill Todd - TeamB
(TeamB cannot respond to email questions. To contact me
 for any other reason remove nospam from my address.)

I specified system file(system.mdw) on BDE, but when open it in Delphi, those
access permission such as 'only read', 'read/write', 'delete' didn't work at
all.
So I set it ODBC driver too. But it worked same.

sounds like Access is using some other system file. Run WRKGADM.EXE on a machine
where security works for access to see what security file it is set to use.

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

I have tried set by BDE or ODBC. But my user level security didn't work.
I have set the user level security like this procedure.

1. set the security stuff in MS-ACCESS.
    password, table access authority etc.
2. open ODBC or BDE.
3. select NEW from the menu.
4. select MSACCESS as a database driver name.
5. specify database name with (*.mdb)
6. specify System DatabaseName with(system.mdw)

I don't know what was wrong.
Anyway, thank you very much.