Re: Partial read-only access

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Nick Coe \(UK\) (classicnickNOSPAMAT_at_MASPON.yahooDOTcom)
Date: 06/11/04 

Date: Fri, 11 Jun 2004 15:18:02 +0100

Generally the most straight forward way of doing this is, if
you have not already done so, to split your application into
Front End (Forms, queries, code, reports) and Back End
(tables).

Make two versions of the FE one where you set the forms to
prohibit alteration or addition of data through the form
properties and the other being normal 'full'
editing/addition and so on.

Then link the BE tables to each FE, you should seriously
consider code in the FE to look after linking if you don't
already have same.

Check out the sites listed here;
http://www.alphacos.co.uk/html/msaccess_tips.htm 

-- 
Nick Coe (UK)
www.alphacos.co.uk
---
"Pow" <idont@wantspam.com> wrote in message
news:OiDmP06TEHA.3660@tk2msftngp13.phx.gbl...
> Hello
>
> At work, we use a Windows 2000 server, with about 45 staff
networked
> together.
>
> One of the departments use an Access database that I
designed.  The
> situation now is we want the rest of the company to use
the same database.
> However, we want to restrict the majority to read-only
access, to prevent
> any record deletion, changing of details etc.  Only a
limited few should
> have full access.
>
> Does anyone have any suggestions, or point me to websites
that can, as to
> how I can achieve this?
>
> Most grateful for your help.
>
>
>
>
>
>
>
>

Relevant Pages

  • Re: database/LabVIEW naming-dependancy blues
    ... This is the reason I like this forum - straight answers when possible and compassion when your code doesn't work:smileysurprised: ... When I use the access database I always stick an autonumber field in ... Queries that read data based on nonindexed fields can become dreadfully slow. ...
    (comp.lang.labview)
  • Re: Data Access Pages
    ... > queries, forms and macros to enable it to be operated over the internet. ... > data can be edited manually via data access forms, ... if there are any example of access database being controlled via web ...
    (microsoft.public.access.modulesdaovba)
  • Re: Access and Excel
    ... via append queries and update queries. ... > Excel spreadsheets. ... > wanting to create some sort of Access database for her as ...
    (microsoft.public.access.tablesdbdesign)
  • Re: office 2003 Word mailmerge with Access
    ... If you aren't able to see all of the queries then ... it's likely due to the connection method rather than permissions. ... Select the Access database as the data source again and when ...
    (microsoft.public.office.misc)
  • Re: Mail merge from access Database
    ... Word 2003 uses a thing called OLE DB to connect to the Access database. ... however, both Access tables and Access Queries are listed in that dialog box, although Queries are described as Views. ... OLE DB does not "see" all types of table and query. ...
    (microsoft.public.word.mailmerge.fields)