I just split my access db, so that 1 (DBa) contains the forms/reports/macros and table links. The other (DBb) contains the tables.
Q: How to go abt maintaining the security for both DB? On DBa, do I need to set the security mode for the tables? Since these are links to tables in DBb? I use join security from DBa to DBb, that means those users/groups in DBa will also be in DBb, rite?
Q: I actually wanted users to update the data thru my forms, but it seems that the users can still open DBb directly and update the data by clicking on the tables. Anyway to prevent this?