As soon as I have developed the database to a point where I want to begin having someone else look at it, I generally go to a FE/BE setup. At this point I do not expect to have to make changes to the database structure, and once the tester (or the client) starts entering data, they generally want to keep the data they have already entered. If you have not split the database at this time, then you have to get a copy of their database and tell them not to do any data changes while you make changes in what should be the front end.
The book "Database Design for Mere Mortals", while not Access-specific, is a good reference for designing a normalized database. You can combine some of the steps that author goes through in designing the database in conjunction with the client, but there are good design principles outlined in this book. Tobi -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Norman Pearce Sent: Tuesday, August 09, 2005 12:23 PM To: [email protected] 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=12hs08ng4/M=362335.6886445.7839731.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123612751/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/";>In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide!</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/
<<application/ms-tnef>>
