Windows 11 
Access 2021
Thus far, I am the only one using the database I created. But now, I need it to be used by others simultaneously while I maintain control over the tables, queries, forms, and code. I just need certain forms to be available to certain people. I am guessing the first step is to split the database. But when I split it, how can I add security so that no one can reasonably access the tables or code directly? My early thoughts are this is not going to work in access and I at least need to convert the tables to sql server after I split the database. If you have any experience in this, can you please tell me what you think works best? Thanks.
Reply With Quote
. Many thanks.
