Linked Tables "Read Only"?

[TheScullster]

Hi all

Total numpty newbie here!
I am linking to tables in an existing database and want to safeguard against
any changes to the back end tables.
Is it possible to declare the link read only?

TIA

Phil

 

[Arvin Meyer [MVP]]

No, but you can make the form read-only, and make sure that the user cannot
find any other way to get at the data.

 

[NG]

Hi Phil,

the safest way to proceed is to create in the back-end database a read-only
user, and use this user account to log in from the access side. This works
fine if the backend is an Oracle or SQl server or similar database system.
If the back-end is another access file, then you might consider to hide the
tables, and provide read-only forms to access the data from the front-end
application.

kind regards
NG

 

[TheScullster]

Hi Phil,

the safest way to proceed is to create in the back-end database a
read-only
user, and use this user account to log in from the access side. This
works
fine if the backend is an Oracle or SQl server or similar database system.
If the back-end is another access file, then you might consider to hide
the
tables, and provide read-only forms to access the data from the front-end
application.

kind regards
NG

Thanks NG and Arvin