SQL Linked Tables

[Guest]

Sorry - I haven't used Access in a long time .....

I have 4 SQL linked tables.
A select Query is run on the SQL data.
A form opens, containing SQL data, as well as additional fields that I have
added in Access so that the enduser can enter data not contained in the SQL
database.
A report is then generated with the SQL data and enduser entered data.

Question 1 - Is my link to SQL one way? I only want the enduser to read the
SQL data, not be able to write to the SQL database.

Question 2 - Does the link automatically refresh upon opening Access, or
does the enduser need to refresh the data?

 

[Rick Brandt]

Sorry - I haven't used Access in a long time .....

I have 4 SQL linked tables.
A select Query is run on the SQL data.
A form opens, containing SQL data, as well as additional fields that
I have added in Access so that the enduser can enter data not
contained in the SQL database.
A report is then generated with the SQL data and enduser entered data.

Question 1 - Is my link to SQL one way? I only want the enduser to
read the SQL data, not be able to write to the SQL database.

If the table on the server has a Primary Key or at least one unique index
then the link will usually be editable. An easy test is to open the link's
datasheet and see if you can make any changes.

If the link is editable, but you don't give the users permissions to perform
edits on the server then they will get an ODBC error if they try to make
changes.

Question 2 - Does the link automatically refresh upon opening Access,
or does the enduser need to refresh the data?\

It should refresh automatically.

 

[Arvin Meyer [MVP]]

Typically, Access uses bound forms which means that the data is always
refreshed when the form is opened or report is run. The data is also
editable. You can go into the form's design view and disable and/or lock
each control that you do not want edited. Make sure that you hide the
database window in the starup options and use a menu or form to open the
forms and reports you want them to see. All objects can be edited from the
tables/queries in the database window if they have SQL-Server permissions.
You can permanently hide the database window to keep users from ever getting
there, but I find that if you have users who continuously do what there not
supposed to be doing, it's better to get rid of them.