Brian, Let's not beat-up on the messenger. He apparently has the "user from Hell" who is demanding this crappy design. Also, you can do client/server with access. Separate all the tables into one MDB (called the back-end?) and everything else into another (called the front-end?) Copy the front end to each of the client PCs. Of course you have to link the front-ends to the back-end via the Linked Table Manager. Dick
--- In [email protected], "Brian E Boothe" <[EMAIL PROTECTED]> wrote: > > I,m not really understanding why anyone would trouble themselves in creating > a huge Project as that in MsAccess for an organization when it can't be a > true Client /server based application >? It seems that access isn't > Distributed at all why would u do that ? u mention datasource aren't u > talking about yourself as the access database to separate database? , > unless u wanna connect another field to another database, then your Zagging > all over the place , that seems a terrible mess to be in , 250 fields???? > Dear god man ,, what is that application, > > > > > > > > _____ > > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of [EMAIL PROTECTED] > Sent: Tuesday, November 07, 2006 7:06 PM > To: [email protected] > Subject: RE: [ms_access] CAN AN ACCESS FORM HAVE MORE THAN ONE DATA SOURCE? > > > > Try using a sub-form. > > Guy Harley > > www.youramigo.-com > > _____ > > From: HYPERLINK > "mailto:ms_access%40yahoogroups.com"[EMAIL PROTECTED] > [mailto:HYPERLINK > "mailto:ms_access%40yahoogroups.com"[EMAIL PROTECTED] On Behalf > Of rlee_at_channing > Sent: Wednesday, 8 November 2006 10:54 AM > To: HYPERLINK "mailto:ms_access%40yahoogroups.com"[EMAIL PROTECTED] > Subject: [ms_access] CAN AN ACCESS FORM HAVE MORE THAN ONE DATA SOURCE? > > I'm in a bit of a quandry here. I built this form containing > 250 or so fields all from one data source. The person I'm working for > wanted to add another 100 or so fields to the form so I had to build a > new table to house the 100 new fields. But when I went back to the > form to see if I could add the new fields from the new table, I got > stuck. > Is there a way to add fields from another data source to the form? > > Regards, > > Ryan > > [Non-text portions of this message have been removed] > > > > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.1.409 / Virus Database: 268.13.32/523 - Release Date: 11/7/2006 > > > > -- > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.1.409 / Virus Database: 268.14.5/534 - Release Date: 11/14/2006 > > > > [Non-text portions of this message have been removed] >
