Does Microsoft Access security still work if I use OLE automation or Microsoft Query to manipulate Microsoft Access tables?
Yes. Microsoft Access security is set at the Microsoft Jet database engine level, which cannot be overridden by any other application. The Jet database engine verifies that another user or application has sufficient permissions before it hands over any data. Permissions you set for each object will be honored DDE Alert: You must keep one special thing in mind when accessing data via DDE: because you can connect to a currently running session of Microsoft Access, all permissions are decided by the permissions of the user who logged on to that session, not the user who connects via DDE.
