You said in the Simple Security video that the database can be saved as a (ACCDE) file and no changes can be made to the table, form and reports but the administrator or owner can still make changes in the (ACCDB) file. Does this mean that the (ACCDE) is just linked to the (ACCDB) file or are they now two separate unrelated databases?
That's a very good question, and I was thinking about that as I was watching the video myself for the first time after I finished recording it. It is a separate stand-alone database file. What you want to do is set up your links to the back-end tables FIRST in the ACCDB file, and then when you create the ACCDE it will keep the exact same links. Then you distribute it to your users. I should have made that clear in the video.
Garry Smith 2 years ago
Thanks for the response. How can it be relinked if I sent a copy of the database to someone else to use and they are not on a network? Is this possible?
You could use an ODBC connection, or connect via the Internet to Sharepoint or SQL Server. I cover one such scenario in my Sharepoint Seminar. I show how to do it with SQL Server on GoDaddy in Access Expert 24.