<!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.1106" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=877315017-01072003><FONT face=Arial color=#0000ff size=2>I've
never done it but how about something like this:</FONT></SPAN></DIV>
<DIV><SPAN class=877315017-01072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=877315017-01072003><FONT face=Arial color=#0000ff size=2>Put
some functionality in the vanilla version that checks for the existence of a
custom.mdb in the same directory as the vanilla front end. If it's there,
then open it and import the custom objects into the working interface. You
could have a Custom options menu item on your main menu that would open
another menu that would drive your Custom options. This Custom options
menu would exist in the custom.mdb and be imported with the other custom
objects. If you will be importing objects from the custom.mdb that have
the same names as objects in your vanilla front end, your code will need
to delete the object in the vanilla front end before importing the custom
object.</FONT></SPAN></DIV>
<DIV><SPAN class=877315017-01072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=877315017-01072003><FONT face=Arial color=#0000ff size=2>If you
are running the front end on the local hard drive, you could copy the
custom.mdb to their hard drive as well. Then you are only modifying the
copy of the front end. The master copy of the vanilla front end remains
untouched. Any additional customizations are added to the custom.mdb which
is then copied down to the local hard drive.</FONT></SPAN></DIV>
<DIV><SPAN class=877315017-01072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma><FONT
size=2><SPAN class=877315017-01072003><FONT face=Arial color=#0000ff> You
would need code to:</FONT></SPAN></FONT></FONT></DIV>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT><FONT face=Arial
color=#0000ff size=2><SPAN class=877315017-01072003>A. Search for the existence
of custom.mdb in the same directory as your running front
end</SPAN></FONT></FONT></DIV>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT><FONT face=Arial
color=#0000ff size=2><SPAN class=877315017-01072003>B. Spin through the list of
objects in the custom.mdb and compare the names to the list of objects in the
vanilla front end AND if any match, delete them in the vanilla front
end.</SPAN></FONT></FONT></DIV>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT><FONT face=Arial
color=#0000ff size=2><SPAN class=877315017-01072003>C. Import the objects from
the custom.mdb</SPAN></FONT></FONT></DIV>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT><FONT face=Arial
color=#0000ff size=2><SPAN
class=877315017-01072003></SPAN></FONT></FONT> </DIV>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT><FONT face=Arial
color=#0000ff size=2><SPAN class=877315017-01072003>I've already setup a
test.mdb and a custom.mdb and will be working on the code to do this so if you
need a sample let me know and I'll try to have something for you
soon.</SPAN></FONT></FONT></DIV>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT><FONT face=Arial
color=#0000ff size=2><SPAN
class=877315017-01072003></SPAN></FONT></FONT> </DIV>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT><FONT face=Arial
color=#0000ff size=2><SPAN
class=877315017-01072003>HTH</SPAN></FONT></FONT></DIV>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT><FONT face=Arial
color=#0000ff size=2><SPAN
class=877315017-01072003></SPAN></FONT></FONT> </DIV>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT><FONT face=Arial
color=#0000ff size=2><SPAN
class=877315017-01072003>Rusty</SPAN></FONT></FONT></DIV>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma><FONT
size=2><SPAN class=877315017-01072003></SPAN></FONT></FONT> </DIV>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma><FONT
size=2><SPAN class=877315017-01072003> </SPAN>-----Original
Message-----<BR><B>From:</B> John Colby
[mailto:jcolby@colbyconsulting.com]<BR><B>Sent:</B> Tuesday, July 01, 2003 12: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></DIV></FONT></FONT>
<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><FONT face=Arial color=#0000ff size=2></FONT> </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></FONT></BODY></HTML>