[AccessD] Two front end databases with one user interface?

MessageHi, Charles.... There seems to be a problem with the link...............Barb
  ----- Original Message ----- 
  From: Wortz, Charles 
  To: Access Developers discussion and problem solving 
  Sent: Tuesday, July 01, 2003 2:06 PM
  Subject: RE: [AccessD] Two front end databases with one user interface?


  Barb,

  See Terri Jarus "E-mail Acronyms" at www.databaseadvisors.com/newsletters/7602-2wr.htm.


  Charles Wortz 
  Software Development Division 
  Texas Education Agency 
  1701 N. Congress Ave 
  Austin, TX 78701-1494 
  512-463-9493 
  CWortz at tea.state.tx.us 

  -----Original Message-----
  From: Barbara Ryan [mailto:BarbaraRyan at cox.net] 
  Sent: Tuesday 2003 Jul 01 13:08
  To: Access Developers discussion and problem solving
  Subject: Re: [AccessD] Two front end databases with one user interface?


   Thanks, John......

  I was hoping to limit the number of objects in my "vanilla" front end by keeping the "really specific" customizations in another FE.  

  This is funny--- I didn't quite catch on to the acronym "PITA" --- I thought it must be some high-tech thing, so I did a search in Google. Found the "Palestine Information Technology Association", the "Pacific Islands Telecommunications Association", the Pacific International Trapshooting Association....

  ...but it just clicked --- that it's a Pain......

  Barb
  ----- Original Message ----- 
    From: John Bartow 
    To: Access Developers discussion and problem solving 
    Sent: Tuesday, July 01, 2003 1:27 PM
    Subject: RE: [AccessD] Two front end databases with one user interface?


    I do something kind of similar with an app. Its a PITA!

    It entails using a login (which I have happen automatically based on the windows login if it matches the staff table info). I then hold info in variables about about what the person can see and if necessary how they see it.

    So for instance if the forms a person is allowed to see, based the department they work for and their "security" (my built in security-not access's) then they just don't get the icons for the other forms displayed. When there is a choice of forms to use for the same info they get "their" version of the form. How the position their forms is called everytime a form opens and reset to the postion when it closes. 

    I store some of this info (personal choices for UI settings) in the registry and other info (such as security-which is required in case they login into someone elses PC) in the "staff" table.

    BTW did I mention that its a PITA?

    I suppose you could get it set up in a class framework but I haven't gone there yet.
    HTH
    JB

    PS: did I mention that its a PITA?
    :o)



------------------------------------------------------------------------------


  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030701/bcda766f/attachment-0001.html>