ODBC security

doesnt work?

OK. I have an Access 2000 db. ODBC on windows and php+ apache web server.

<? 
$odbc = odbc_connect ('Invoicedb', 'Admins', 'sss') or die( "Could Not Connect to ODBC Database!" );
?

always works whatever the username or password!?

I changed the user account in MS Access and in the ODBC settings I created a password for admin but still whatever I try I can connect. ?

What is a good way to implement user access rights to a Access Database?

PS: NOOB asking

Access sucks for security. It's not a proper mutli-user db, so security was never a consideration. There are several possibilities below:

You can try using .htaccess to prevent unatuhorized users from accessing your script.
Switch to a real DB (mySql, postgreSql, Oracle, MSSQL etc)
Store scripts that access the db in a different folder and use the OS to manage the security or use logins to manage the users

Originally posted by bastien
Access sucks for security. It's not a proper mutli-user db, so security was never a consideration.

For the same reason, it sucks for multi-user environments - more than ten or so concurrent requests and my experience is that it will go bye-bye.