I'm not sure about some good references but I can tell you that the main two advantages I see to using a FE/BE setup are:
1. Ability to edit and replace the FE without worrying about the data in the BE. Think about having a "live" database where the data is being changed all the time. If you had all the Queries, Forms, Reports, etc. (FE) in the same file as the Tables (BE), then every time you edited a Query, Form, Report, etc., you would have to manually copy over the live data from the "live" database before replacing the old file with the edited one. 2. Ability to customize multiple FE databases to interact with a signle BE database. Say you want to program a Timekeeping application, and you want to have two stations to clock in/out. This is difficult to do without using a FE/BE setup. You would have two separate databases with two different sets of data. Sure, you could setup a routine to merge the data later, but wouldn't it just be easier to create a single BE, and link to it from each of the FE's. Then all of the data is "live" instead of being collected as batches of data and merged after the fact. Plus, this allows users to clock in at one station and clock out at the other. Also, consider if you wanted a third FE customized for Payroll, who could monitor or interact live with the data. HTH, Toby ----- Original Message ----- From: "Norman Pearce" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, August 09, 2005 9:23 AM Subject: [AccessDevelopers] Database Design - FE/BE Can anybody point to some good references regarding the initial design of Access Databases for a FE/BE application. What are your recommendations for "Best Practice"? To date I have never used/designed a FE/BE & just do not know at what piont you start thinking of the FE/BE architecture. How do you maintain referential integrity via the relationships in a FE/BE. TIA Norman Pearce Ealing Hospital UK Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hjs942d/M=362329.6886308.7839368.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123613448/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992 ">Fair play? Video games influencing politics. Click and talk back!</a>.</font> --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> 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/
