Basically, this is how it would work. You'de set up the backend with all of your tables (you could probably "Import" them from your existing multiple databases). Then, you would set up your front ends and link them to the tables located in the back end by selecting File/Get External Data/Link Tables and then follow the prompts. You would only need to link the tables that that particular front end needs. From there, you would set up your forms/queries etc. in each front end (again, you would only set up the forms that pertain to that particular front end). So, when you are done, the structure tree would look something like this:
Backend |-Front end #1 |-Front end #2 |-Front end #3 All of the front ends would report back to the tables in the back end when adding records, etc. So, basically, none of the front ends would have tables in them, just links to the tables in the backend. The front ends would only contain the forms, queries, etc. I'm probably not explaining this very well, but once you do it once, it's not very difficult. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lynn Sent: Monday, November 28, 2005 3:00 PM To: [email protected] Subject: [ms_access] Re: Multiple db feed? Thanks! Would that be done similarly to a link up of an Excel Spreadsheet to a DB when using the s/h as a Table? Lynn Bryant Ball Ground, GA --- In [email protected], "Mike Bisson" <[EMAIL PROTECTED]> wrote: > > 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 Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/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/
