how to open a access DB using ADODB connection in VB

[Divakar Ragu]

I am using ADODB connection to connect Access DB via VB front end application.

I have requirement that if login as Admin in the application i should have read/write access Else i should have read access.

I have set up to id in Access db that is "Admin" and "User".

I have assigned appropriate permissions as well. Now the question is how to mention in my VB code to connect the DB via Admin or User (normal user)?

Thanks in Advance