<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=968291517-01072003><FONT face=Arial color=#0000ff size=2>I do
something kind of similar with an app. Its a PITA!</FONT></SPAN></DIV>
<DIV><SPAN class=968291517-01072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=968291517-01072003><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=968291517-01072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=968291517-01072003><FONT face=Arial color=#0000ff size=2>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. </FONT></SPAN></DIV>
<DIV><SPAN class=968291517-01072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=968291517-01072003><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=968291517-01072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=968291517-01072003><FONT face=Arial color=#0000ff size=2>BTW
did I mention that its a PITA?</FONT></SPAN></DIV>
<DIV><SPAN class=968291517-01072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=968291517-01072003><FONT face=Arial color=#0000ff size=2>I
suppose you could get it set up in a class framework but I haven't gone there
yet.</FONT></SPAN></DIV>
<DIV><SPAN class=968291517-01072003><FONT face=Arial color=#0000ff
size=2>HTH</FONT></SPAN></DIV>
<DIV><SPAN class=968291517-01072003><FONT face=Arial color=#0000ff
size=2>JB</FONT></SPAN></DIV>
<DIV><SPAN class=968291517-01072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=968291517-01072003><FONT face=Arial color=#0000ff
size=2>PS: <SPAN class=968291517-01072003><FONT face=Arial color=#0000ff
size=2>did I mention that its a PITA?</FONT></SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=968291517-01072003><FONT face=Arial color=#0000ff size=2><SPAN
class=968291517-01072003>:o)</SPAN></FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Barbara
Ryan<BR><B>Sent:</B> Tuesday, July 01, 2003 12:04 PM<BR><B>To:</B> Access
List<BR><B>Subject:</B> [AccessD] Two front end databases with one user
interface?<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Hope this makes sense!<BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Thanks,</FONT></DIV>
<DIV><FONT face=Arial size=2>Barb Ryan</DIV></BLOCKQUOTE></FONT></BODY></HTML>