Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / December 2007

Tip: Looking for answers? Try searching our database.

Design Problem-Where to get started?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
cruiser - 31 Dec 2007 14:42 GMT
Access neophyte. Have access database with following characteristeics
1. Main record (publication)
2. subrecord (source)-multiple for each main record.

required result:
a. multilevell Pasword protection
 1. Superuser/administrotor (full proivledges)
 2. general user (querry/display only)
b. querry by publication, display of subrecord only

the querry/display interface is very specific. Querry input is to be main
record only,
display is to be subrecord only.

any suggesgtions would be greatly apprreciated
Ken Sheridan - 31 Dec 2007 18:26 GMT
To provide different levels of security for the administrator and general
users you'll need to implement user and group security.  You'll find
extensive details of how to do this at:

http://support.microsoft.com/default.aspx?scid=%2Fsupport%2Faccess%2Fcontent%2Fs
ecfaq.asp


If you read the article carefully and take it step by step you shouldn't
find it too difficult to achieve what you want.  Be sure to make a back-up of
the unsecured database first, though, so you have something on which to fall
back if required.

As regards the user interface for querying the database it sounds to me like
you need an unbound form with a combo box from which you can select a
publication and a bound subform within it to return the rows from the sources
table for the selected publication.  If you are using a surrogate key for the
publications table, e.g. a PublicationID autonumber then the combo box would
have this column as its bound column but show the publication name.  For this
you'd set up the combo box along these lines:

RowSource:     SELECT PublicationID, PublicationName FROM Publications ORDER
BY PublicationName;

BoundColum:   1
ColumnCount:  2
ColumnWidths  0cm;8cm

If your units of measurement are imperial rather than metric Access will
automatically convert the last one.  The important thing is that the first
dimension is zero to hide the first column and that the second is at least as
wide as the combo box.

The subform would be based on the Sources table and the LinkMasterFields
property of the subform control would be the name of the unbound combo box in
the parent form, e.g. cboPublication; the LinkChildFields property would be
the name of the foreign key column in the sources table, e.g. PublicationID,
which references the key of the publications table.

Ken Sheridan
Stafford, England

> Access neophyte. Have access database with following characteristeics
> 1. Main record (publication)
[quoted text clipped - 11 lines]
>
> any suggesgtions would be greatly apprreciated
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.