If your question is can you open a connection to more than one physcial database at the same time then the answer is yes. However, if you are going to do this the frontend should be completely divorced from either backend. If you don't understand that statement then you need to get the information on that (explained in many places here and elsewhere already) and the rest should be self explanatory.
Good Luck --- lewiskidd <[EMAIL PROTECTED]> wrote: > Dear All, > > Is there some kind person or people who can help me > resolve a > problem that I have ? > > Dependant upon the data entry to database 1 > (resapps) I need to > either a take no further actions (Instances of > rejection) or further > action (Instances of acceptance) open database 2 > (sholas). > > I was hoping that some form of vba code could > perhaps be used, there > are two combo boxes that I feel sure hold the key to > opening > database 2 (sholas). If both the combo box offering > granted or > refused for final decision were used along with the > member's combo > box again offering granted and refused. If both > selections of > granted were made this would then invoke the vba > code which in turn > would open the second database. > > Can someone please help me with this > > > > Rgds > > > > Lewis > > > > > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessVBACentral/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
