DSN-less Access database connection -- ignoring password/username

[jenlynn]

I'm having problems with an online access database. I have set up security on the database. When I try to open the database from within Access, I have to enter my username and password for writing permission. This is great, but when I transfer the database to the web, the database will allow updates without using the username/password that I pass to the dsn-less connection string from a login form. Here is my connection string:

$strConn = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("mydatabase.mdb"); "UID='$USERNAME'; PWD='$PASSWD'";

Any help on this would be greatly appreciated.