Hey all, i'm using ODBC to link to a mySQL backend. These tables get linked at startup, and i'd like to protect them.

How do you do user-level security in a programatic way?

I want to have some security to this system, and with a MDW file i can set default security for the newly linked tables, but there may be some tables i don't want the user to open at all. How do i manage the MDW accounts through the VBA code?