Re: Multiple Users from differant sites accessing the same Databas

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 01/19/05 

Date: Wed, 19 Jan 2005 14:00:14 -0700

On Tue, 18 Jan 2005 22:43:02 -0800, "Matt"
<Matt@discussions.microsoft.com> wrote:

>If anyone out there is able to help me with the direct question - "All
>> >I'm really looking for is to be able to assign a hidden attribute (Site Code)
>> >to each entry a user makes. A username\password system would be handy as
>> >then we wouldnt have to worry about another user from a differant site .........."
>
>It would be greatly appreciated.

Here's one scenario:

Each Citrix client is connected to a separate, Windows Security
protected folder on the Citrix server; they'll only be able to see
their own folder. In each such folder there is a customized Access
frontend database.

The backend database has a field SiteCode (don't use blanks in
fieldnames!) field in each table where you want to track the data.

Each frontend has Forms to update the data in the tables. On each Form
there is a textbox bound to that table's SiteCode field; the
properties of the textbox are:

Enabled = No
Locked = Yes
Visible = No
TabStop = No
DefaultValue = <that user's Site Code>

                  John W. Vinson[MVP]