<!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=614421420-02072003><FONT face=Arial color=#0000ff
size=2>Barbara,</FONT></SPAN></DIV>
<DIV><SPAN class=614421420-02072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=614421420-02072003><FONT face=Arial color=#0000ff size=2>I've
sent you two mdb files with the code and some sample objects
offline.</FONT></SPAN></DIV>
<DIV><SPAN class=614421420-02072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=614421420-02072003><FONT face=Arial color=#0000ff
size=2>Rusty</FONT></SPAN></DIV>
<DIV><SPAN class=614421420-02072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Barbara Ryan
[mailto:BarbaraRyan@cox.net]<BR><B>Sent:</B> Tuesday, July 01, 2003 2:23
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><FONT face=Arial size=2>Rusty.... This sounds like something that would
work really well for me. I would love to have a sample of the
code...........Thanks, Barb</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=rusty.hammond@cpiqpc.com
href="mailto:rusty.hammond@cpiqpc.com">rusty.hammond@cpiqpc.com</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, July 01, 2003 2:46
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=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 size=+0><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 size=+0><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 size=+0><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 size=+0><FONT
face=Arial color=#0000ff size=2><SPAN
class=877315017-01072003></SPAN></FONT></FONT> </DIV>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT size=+0><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 size=+0><FONT
face=Arial color=#0000ff size=2><SPAN
class=877315017-01072003></SPAN></FONT></FONT> </DIV>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT size=+0><FONT
face=Arial color=#0000ff size=2><SPAN
class=877315017-01072003>HTH</SPAN></FONT></FONT></DIV>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT size=+0><FONT
face=Arial color=#0000ff size=2><SPAN
class=877315017-01072003></SPAN></FONT></FONT> </DIV>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT size=+0><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>
<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>