ONE TO ONE DILEMMA

S

sam1967

I have been forced to split a table in two for security reasons and it
is giving me a headache.

I find it is easier to enter the firstname and surname in both tables
but realise i am duplicating effort. But it makes it easier tto work
with.

Has anyone ever done this in a ONE-ONE table situation ?
 
S

Scott McDaniel

Not sure this is the appropriate group to ask this, but ...

If you find that you are duplicating data between tables, then you haven't
setup your database correctly. There are some very good reasons to flatten
or de-normalize data, but those reasons usually deal with reporting, not
data storage. Can you not break out the firstname and surname data into
another table and reference that table from both of your existing tables?
 
T

TC

[email protected] said:
by giving one user access to one table and the other user no access.
Click to expand...


If the data really belongs in a single table (from a data modelling
viewpoint), you may be better off to use other security methods to
control which users can access what records from that one table.

You can do this by marking each record with some identifying
information (eg. the username who created the record), then have a
query that returns selected subsets of records, depending on the
current user. If this is a Run With Owner Permission (RWOP) query, you
could set it up so that the users did *not* have *any* access to the
underlying table. They could only get to the data by using the RWOP
query. And the RWOP query would control exactly *what records* were
given to each user.

HTH,
TC
 
L

Lynn Trapp

Sam,
Have you implemented Access User Level security? If so, the best approach is
to leave all the data in one table. Remove all permissions to the table to
the users who are not supposed to see the secure data. Then create a RWOP
(Run With Owner's Permissions) Query to give those users access to the
non-secure data. The Security FAQ explains how to do this. There is a link
to it on the Security page of my website.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format column widths from one table to a separate table on same page 1
Footnote references on one page, footnote text on the next 5
Automatically sending multiple parts of text from one word doc to another - is possible. 0
List all tables, including document structure 0
VBA: Programmatically clear a one-key shortcut bound to a document 2
How to paste this down? 3
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Microsoft 365 Activations, Users or Devices? 0

Top