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

Thanks, John....That gives me some options to think about..............Barb
  ----- Original Message ----- 
  From: John Bartow 
  To: Access Developers discussion and problem solving 
  Sent: Tuesday, July 01, 2003 2:23 PM
  Subject: RE: [AccessD] Two front end databases with one user interface?


  Barb,
  You could do that but instead of presenting a different form in the FE for that user open a different form in another FE. I did that with one of the apps until it was fully integrated into the main FE.

  Of course this was the entire app. If you're opening one specific form and there is more than just that one form in the other FE then you'de have to work something out for that. Maybe put each special form in its own FE? (Thats just a wild swing at a solution, could get ugly.)

  Select Case gintDeptID
  Case "PITA depart."
      Dim strStAppName As String
      strStAppName = "C:\Program Files\Access 97 Runtime\Msaccess.exe ""N:\PITAForm1.mde"""
      Call Shell(strStAppName, 1)
  Case Else
      "open the vanilla form"
  End Select

  JB
    -----Original Message-----
    From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Barbara Ryan
    Sent: Tuesday, July 01, 2003 1:08 PM
    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)
        -----Original Message-----
        From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Barbara Ryan
        Sent: Tuesday, July 01, 2003 12:04 PM
        To: Access List
        Subject: [AccessD] Two front end databases with one user interface?


        I have a "vanilla" Access 97 application that is used at multiple sites.  If a particular site want a modification --- e.g., a customized version that I do NOT want to incorporate into the vanilla version, is there a way that I can create a separate front end (to hold these custom objects) yet still have one user interface?  I don't want them to have to open two separate applications.

        Hope this makes sense!

        Thanks,
        Barb Ryan


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


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



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


  _______________________________________________
  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/b046fe65/attachment-0001.html>