I have a couple of Access databases that are on a server and regularly shared by 5-10 people. It's been suggested to me that I consider splitting one or both of these databases into a back-end (containing the tables/data) and a front-end (containing all other objects). Can somebody spell out for me the advantages and disadvantages of splitting a database? Are you less likely to corrupt data or a database used by multiple users when it's split? When is it a good idea to split a database, and when are you better off leaving it alone? Is there already a FAQ on this subject?
Thanks for your help.
Walt
Thanks for your help.
Walt