Hi everyone. Not sure if this is even possible, but I thought I would ask.
I have been looking into "dbc_BeforeOpenTable" in order to add security to the tables in my database. However, I have run into a problem:

1. I would like to be able to use dbc_BeforeOpenTable to look up names and passwords in a separate table, but haven't been able to do this. The only samples I have seen using dbc_BeforeOpenTable is with the password written directly into the database stored procedure. This doesn't seem too secure too me and doesn't offer additional benefits of having separate names and passwords. However, even with a separate table with logins and passwords, I will run into problems since someone will be able to simply browse the "login" table to get the passwords, which defeats the purpose.

Does anyone have any suggestions? Thanks.

Paul