Solved

Microsoft Access 2007

Posted on 2011-09-26
1
210 Views
Last Modified: 2012-05-12
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
0
Comment
Question by:mullykid
1 Comment
 
LVL 20

Accepted Solution

by:
clarkscott earned 500 total points
ID: 36598787
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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Access 2016 Query with Proper Case logic 2 35
IIF in access query 19 26
Populating datasheet subform from VBA 6 15
Run Access2013-32bit under WinXP? 4 36
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

827 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question