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" wrote:

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


.