Re: Multiple Users from differant sites accessing the same Databas
From: Matt (Matt_at_discussions.microsoft.com)
Date: 01/19/05
- Next message: TonyB: "Custom Validation Rules"
- Previous message: John Vinson: "Re: Multiple Users from differant sites accessing the same Databas"
- In reply to: John Vinson: "Re: Multiple Users from differant sites accessing the same Databas"
- Next in thread: Lynn Trapp: "Re: Multiple Users from differant sites accessing the same Databas"
- Reply: Lynn Trapp: "Re: Multiple Users from differant sites accessing the same Databas"
- Reply: John Vinson: "Re: Multiple Users from differant sites accessing the same Databas"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 18 Jan 2005 22:43:02 -0800
Thankyou for your reply.
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.
"John Vinson" wrote:
> On Tue, 18 Jan 2005 21:15:02 -0800, "Matt"
> <Matt@discussions.microsoft.com> wrote:
>
> >We are currently running a Records Management Database via Citrix to our
> >remote sites which can has on average 40 Users at one time just on that
> >database alone and we have not had any reported slow-downs or problems.
> >
> >If anyone has some positive feedback it would be greatly appreciated. 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
> >accidentally entering data to an incorrect site.
> >
> >Or, is it possible to have a drop down box which will assign the Site Code
> >to each entry they make?
>
> Citrix is indeed a good way to handle this. One of my clients is doing
> so.
>
> He has multiple users logging on to a Citrix server. Each of them has
> a personal folder containing the frontend (a .mde file, though a .mdb
> would work as well) Access database; all of these are linked to the
> shared backend database on the same server. He's done it running the
> Access instances on the Citrix server, and on a different machine on
> the same LAN - no major differences. He's implemented Access security
> on the database so that each user is identified; it would be very easy
> to have each frontend .mdb file have a site code default of its own,
> if that were necessary.
>
> As noted elsethread, what you do NOT want to do is have the Access
> backend database on one end of the remote network, and an Access
> frontend on the other. However, if the "wire" is only transmitting
> terminal information (as it is with Citrix) this is a very practical
> approach.
>
> John W. Vinson[MVP]
>
- Next message: TonyB: "Custom Validation Rules"
- Previous message: John Vinson: "Re: Multiple Users from differant sites accessing the same Databas"
- In reply to: John Vinson: "Re: Multiple Users from differant sites accessing the same Databas"
- Next in thread: Lynn Trapp: "Re: Multiple Users from differant sites accessing the same Databas"
- Reply: Lynn Trapp: "Re: Multiple Users from differant sites accessing the same Databas"
- Reply: John Vinson: "Re: Multiple Users from differant sites accessing the same Databas"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
