Read Only Link

  • Thread starter Thread starter TIML
  • Start date Start date
T

TIML

I am using Access 2000 and have set up a link to a database via ODBC. I
can't figure out how to make that link read only so that no one can change
any of the data.

Tim
 
Tim,

Are you linking to SQL Server? If so then you don't handle that through the
link (I shoudn't say Not, but not that I know of). You need to either set
up table permissions on the server or though the access form

Another way to keep the tables from being updatable is to remove the
Identity Insert property on fields that contain them. This will allow you
to update from the server but not from Access.

God Bless,

Mark A. Sam
 
TIML said:
I am using Access 2000 and have set up a link to a database via ODBC. I
can't figure out how to make that link read only so that no one can change
any of the data.
Click to expand...

IMO if you want a read-only link then don't use a link. Create a simple
passthrough query of...

SELECT * FROM YourTableOrView

It takes no longer than a link to create and passthroughs are automatically read
only.
 
Back
Top