I would do a "backend" database which contains all of the tables and link the multiple "Front-ends" to the backend. Each front end could have it's own set of forms, queries, etc...
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lynn Sent: Monday, November 28, 2005 9:50 AM To: [email protected] Subject: [ms_access] Multiple db feed? Hi folks, I need to know if the following is possible and if so, the best place to learn how to do it. We have several similar clients, though each one is dissimilar enough to require it's own db. From those individual db's there are approximately 15 fields that we would like to capture data from IN A MASTER DB. In other words, when I enter data into [ISO Code] on the XYZ DB, I'd like it to also fill a field on a Master DB and by the same token, if I enter data into [ISO Code] on the ABC DB, it needs to feed the Master in the same way. So, is this possible and what is the best way to learn how to do it? Thanks much, Lynn Bryant Ball Ground, GA Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> AIDS in India: A "lurking bomb." Click and help stop AIDS now. http://us.click.yahoo.com/VpTY2A/lzNLAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> 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/
