Read Only Link

[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

 

[Mark A. Sam]

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

 

[Rick Brandt]

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.

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.