If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linked Tables "Read Only"?
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 |
#2
|
|||
|
|||
Linked Tables "Read Only"?
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. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access "TheScullster" wrote in message . uk... 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 |
#3
|
|||
|
|||
Linked Tables "Read Only"?
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 . |
#4
|
|||
|
|||
Linked Tables "Read Only"?
"NG" wrote 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 |
Thread Tools | |
Display Modes | |
|
|