Re: Multiple Users from differant sites accessing the same Databas
From: Lynn Trapp (ltrappNoSpam_at_ltcomputerdesigns.com)
Date: 01/19/05
- Next message: Lynn Trapp: "Re: Primary Keys (to autonumber or not ?)"
- Previous message: Allen Browne: "Re: Custom Validation Rules"
- In reply to: Matt: "Re: Multiple Users from differant sites accessing the same Databas"
- Next in thread: John Vinson: "Re: Multiple Users from differant sites accessing the same Databas"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 19 Jan 2005 07:36:26 -0600
Matt,
The ideal solution sould be to implement Access's user level security, but I
have never implemented it in a Citrix environment and don't know how well,
if at all, it would work. You may need to create a table in the database
that stores the site code and a password associated with it. Then create a
form that the users see when they open the data base and allows them to
enter the site code and password. Then, that value could be used throughout
the session. The hard part is that you would need to add a "Who" field to
all your tables and have your application enter the site code in that field
whenever a user creates a new record.
-- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm "Matt" <Matt@discussions.microsoft.com> wrote in message news:A841C266-79F3-465C-9775-BA4D874CCB38@microsoft.com... > 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: Lynn Trapp: "Re: Primary Keys (to autonumber or not ?)"
- Previous message: Allen Browne: "Re: Custom Validation Rules"
- In reply to: Matt: "Re: Multiple Users from differant sites accessing the same Databas"
- Next in thread: John Vinson: "Re: Multiple Users from differant sites accessing the same Databas"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
