Microsoft Access 2007

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
mullykidAsked:
Who is Participating?
 
clarkscottConnect With a Mentor Commented:
1.  You can install the Access Runtime exe and run your Access app like an exe.
2.  You can control anything you want (use access to forms, fields, etc.)
3.  Yes.

Scott C
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.