Yes, that should work (providing you don't have tables with the same name in more then one database)
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lynn Sent: Monday, November 28, 2005 3:59 PM To: [email protected] Subject: [ms_access] Re: Multiple db feed? It's sorta clear. ;) I already have all the 'front-ends' completed. I think it would be a matter of working backwards, so to speak. Set up a backend, then export copies of my tables to it? Lynn Bryant Ball Ground, GA --- In [email protected], "Mike Bisson" <[EMAIL PROTECTED]> wrote: > > 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 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/
