I wish to distribute my access forms to customers who do not have MS Access, i.e. they will execute them via the run time library.
My forms contain links to SQL Server DB tables only. These links need to be changed per customer during configuration/installation. The table names will be the same, but the host name, DB user, DB name may not.
Please tell me this is possible! I can't find out how to it. Do I need to create a form to handle it?