Morninng gurus,
I have a general question concerning tables. It may sound silly, but I'd like to have it done right the first time.
At the moment I have multiple front end mdbs which users utilize for daily activities. My thoughts are that I'd like to centralize all of them so that the data is stored in 1 external mdb. That way, any cross referencing will be in sync.
My question is this:
Is it bad practice to localize ALL data tables into one external mdb? If so, at what point does it become bad practice or is it just bad design all together? The plan is to have it auto-backup daily so that corruption, if any, would only be limited to that time frame. I'd like to avoid corruption all together though, so if having everyone connect to the same mdb is bad, I want to know about that also. Alternatively, should I centralize only the tables that are currently being shared (ie. contact info, which wouldn't really be sensitive to 1 day of corruption) and keep everything else separate?
I appreciate any thoughts.