<!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>Steve.... </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Once the 2nd .mdb is registered as a library of the
1st .mdb, can it be modified easily (i.e., additional objects added)?? I
am assuming that all object names within the 2 databases must be unique?
</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Can you point me to any documentation on setting
this up?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks,</FONT></DIV>
<DIV><FONT face=Arial size=2>Barb Ryan</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=sgoodhall@comcast.net href="mailto:sgoodhall@comcast.net">Steve
Goodhall</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 9:31
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=218250200-02072003><FONT face=Arial color=#0000ff
size=2>Perhaps not easy, but if you have 2 FEDB's, you can register one of
them as a "library" of the other one. This will allow you do invoke
functions in the 2nd DB (the "library") from the 1st db. You can use
these functions to open forms, etc. I haven't ever done much with this,
other than build some simple function libraries. You will probably have
to have both FEDB's linked to the tables in the BE.</FONT></SPAN></DIV>
<DIV><SPAN class=218250200-02072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=218250200-02072003><FONT face=Arial color=#0000ff size=2>Note
that you cannot, unfortunately, create a circular reference to permit the 2nd
db to invoke functions in the 1st. I had done this only in A2K, so
just to be sure, I built a Q&D test set in A97 and it seems to
work.</FONT></SPAN></DIV>
<DIV><SPAN class=218250200-02072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=218250200-02072003><FONT face=Arial color=#0000ff
size=2>Regards,</FONT></SPAN></DIV>
<DIV><SPAN class=218250200-02072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=218250200-02072003><FONT face=Arial color=#0000ff
size=2>Steve Goodhall</FONT></SPAN></DIV>
<DIV><SPAN class=218250200-02072003></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="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>John
Colby<BR><B>Sent:</B> Tuesday, July 01, 2003 1:04 PM<BR><B>To:</B> Access
Developers discussion and problem solving<BR><B>Subject:</B> RE: [AccessD]
Two front end databases with one user interface?<BR><BR></FONT></DIV>
<DIV><SPAN class=960460317-01072003><FONT face=Arial color=#0000ff size=2>I
have never found an easy way to do this but thanks for asking the
question.</FONT></SPAN></DIV>
<DIV> </DIV>
<P><FONT size=2>John W. Colby<BR>www.colbyconsulting.com</FONT> </P>
<BLOCKQUOTE dir=ltr style="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 1: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></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>