<!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 5.50.4522.1800" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Thanks, John......</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I was hoping to limit the number of objects in my
"vanilla" front end by keeping the "really specific" customizations in another
FE. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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....</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>...but it just clicked --- that it's a
Pain......</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Barb</FONT></DIV>
<DIV>----- Original Message ----- </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=john@winhaven.net href="mailto:john@winhaven.net">John Bartow</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">Access Developers discussion and
problem solving</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, July 01, 2003 1:27
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] Two front end
databases with one user interface?</DIV>
<DIV><BR></DIV>
<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>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>