Restricting rows by userid

[Debbie]

I'm not sure if this is the right forum for this but it seems to be the
closest to my dilemma. We have a database that sits on a server and we
currently use replication.

In this environment, there are PCs in several group homes that access the
database on the server. We only want each group home to see their data. As
I mentioned, we are using replication but have had problems with it. Can
anyone think of a way to enable each home to see their own data and not
anyone else's? We do have many reports that pull data from all the homes
collectively so we cannot seperate the data. Any ideas would be most
appreciated.
Thanks,
Debbie

 

[Jeff Boyce]

Debbie

Add a field to the data that indicates which "customer" it belongs to. Add
a constant to each front-end that indicates which customer it is.

Good luck

Jeff Boyce
<Access MVP>

 

[Debbie]

Jeff,
Thanks so much for your reply. I understand the first part, i.e. add a
field that identifies which customer the row belongs to. I'm not sure I
follow you on the second part about adding a constant. Can you explain?
Thanks,
Debbie