Link and unlink / restrict info

[Greg]

Several questions:
1. Once you link a file between databases, how do you then unlink.
2. How can I restrict certain info (fields) between two (2) linked files. I
want to include a certain number in an employee database, but not the other
file. All the other info is duplicated in the files.

 

[Jeff Boyce]

Greg

Not sure where you are talking about doing this...

#1 - a "linked" table/file appears as if it were a table. If you want to
delete the link, just highlight it and delete it. Doing this doesn't touch
the original, just the link to it.

#2 - it sounds like you want to have data in two places. If so, that's
usually neither necessary nor a good idea in a relational database. More
info?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[a a r o n . k e m p f]

partitioning data to different users-- can make a lot of sense.

i'd reccomend:

a) moving to SQL Server
b) using VIEWS to create the simple filters of the data that you want
c) link to the views instead of tables, link to different views in
each destination front end.

of course-- I think that linking is a bit of a pain-- I'd just
reccomend moving to ADP and keeping all your data and queries-- where
they belong-- on a database server

 

[david]

You unlink by deleting the link.

You restrict fields by using Owner Permission Queries and
User Level Security.

User Level Security is a bit tricky to set up the first couple of
times - read the security FAQ, try it out, ask questions in the
access.security group. User level security is not actually secure,
but it does simple access control.

The theory is, you remove user permissions from the table,
but let them use special queries you have set up which only
show some fields.

(david)

 

[a a r o n . k e m p f]

COLUMN LEVEL?

oh, only SQL Server does that huh?

and btw; did he tell you that User Level Security has been removed
from Access 2007?