I am looking to use this functionality for the first time. We need a simple interface to allow a customer to edit their business data in 1 of our database tables in MS SQL Server 2008.
I have a few questions that I need help with:
1. Can an Access form be launched outside of MS Access, like an .exe?
2. Can we limit the customer to only view and edit certain tables in the schema?
3. Can we embed custom SQL in the Form?