<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
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.<br />
I have a few questions that I need help with:<br />
<br />
1. Can an Access form be launched outside of MS Access, like an .exe?<br />
2. Can we limit the customer to only view and edit certain tables in the schema?<br />
3. Can we embed custom SQL in the Form?<br />
<br />
Many thanks,<br />
<br />
Iain
</div>
</div>


Hi,

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?

Many thanks,

Iain

Microsoft Access 2007

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.