Hello Access,

  Is there a setting to make access read only
  I want to attach an mdb front end via linked tables so people can
  write there own queries.

  I am trying find a method to make the link read only

-- 
Best regards,
 Arthur                          mailto:ArthurMaloney@s...

the easiest way is to produce query writing tools via forms.  Then produce
an mde file and don't let them get at the database itself.

Steve K


-----Original Message-----
From: Arthur [mailto:ArthurMaloney@s...]
Sent: 13 February 2003 16:28
To: Access
Subject: [access] read only


Hello Access,

  Is there a setting to make access read only
  I want to attach an mdb front end via linked tables so people can
  write there own queries.

  I am trying find a method to make the link read only

--
Best regards,
 Arthur                          mailto:ArthurMaloney@s...

Steve Klein wrote:
> the easiest way is to produce query writing tools via forms.  Then produce
> an mde file and don't let them get at the database itself.

> -----Original Message-----
> From: Arthur [mailto:ArthurMaloney@s...]

>   Is there a setting to make access read only
>   I want to attach an mdb front end via linked tables so people can
>   write there own queries.
> 
>   I am trying find a method to make the link read only.

Can you point us (me) to an example of this? Does it make queries non 
updateable? I have a similar need with a user who has Access on his 
machine and knows just enough to be dangerous. He also goes by Dilbert's 
boss's philosophy that anything he doesn't understand is unimportant and 
can be ignored. Also, the rights to files is an issue. Am I correct in 
thinking that the user must have read, write, and file scan to the back 
end mdb and read, write, create, filescan, and erase to the same name as 
the mdb  dot ldb? I.e. if we are talking about F:\folder\mybackend.mdb, 
he has to be able to create and erase F:\folder\mybackend.ldb.

Paul

> -----Original Message-----
> From: Arthur [mailto:ArthurMaloney@s...]

>   Is there a setting to make access read only
>   I want to attach an mdb front end via linked tables so people can
>   write there own queries.
>
>   I am trying find a method to make the link read only.

Apply Access security to both the front and back end databases. Give your
users read-only access to the tables in the back-end. Give them full access
to the front-end to allow them to write queries.





*************************************************************************

This e-mail may contain confidential information or be privileged. It is intended to be read and used only by the named
recipient(s). If you are not the intended recipient(s) please notify us immediately so that we can make arrangements for its return:
you should not disclose the contents of this e-mail to any other person, or take any copies. Unless stated otherwise by an
authorised individual, nothing contained in this e-mail is intended to create binding legal obligations between us and opinions
expressed are those of the individual author.

The CIS marketing group, which is regulated for Investment Business by the Financial Services Authority, includes:
Co-operative Insurance Society Limited Registered in England number 3615R - for life assurance and pensions
CIS Unit Managers Limited Registered in England and Wales number 2369965  - for unit trusts and PEPs
CIS Policyholder Services Limited Registered in England and Wales number 3390839 - for ISAs and investment products bearing the CIS
name
Registered offices: Miller Street, Manchester M60 0AL   Telephone  0161-832-8686   Internet  http://www.cis.co.uk   E-mail
cis@c...

CIS Deposit and Instant Access Savings Accounts are held with The Co-operative Bank p.l.c., registered in England and Wales number
990937, P.O. Box 101, 1 Balloon Street, Manchester M60 4EP, and administered by CIS Policyholder Services Limited as agent of the
Bank.

CIS is a member of the General Insurance Standards Council

CIS & the CIS logo (R) Co-operative Insurance Society Limited

********************************************************************************