A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Linked Tables "Read Only"?



 
 
Thread Tools Display Modes
  #1  
Old March 29th, 2010, 09:09 AM posted to microsoft.public.access.gettingstarted
TheScullster
external usenet poster
 
Posts: 53
Default 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  
Old March 29th, 2010, 12:08 PM posted to microsoft.public.access.gettingstarted
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default 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  
Old March 29th, 2010, 12:46 PM posted to microsoft.public.access.gettingstarted
NG
external usenet poster
 
Posts: 56
Default 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  
Old March 29th, 2010, 02:01 PM posted to microsoft.public.access.gettingstarted
TheScullster
external usenet poster
 
Posts: 53
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:11 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.