I'm connecting to an Access 97 database that has user level security implemented via ADO from VB6.

My problem is that however I try to login as a particular user (using the connection string,etc), the connection is always opened as the 'Admin' user. This user has no rights and therefore I cannot do what I want in the DB.

Has anybody had any similar problems?

Is the right way to specify the user to have an expression like 'UID=(username)' in the connection string before opening?

Any help appreciated.

Thanks.