Page 2 of 2

Posted: Wed Jan 10, 2007 2:09 pm
by TheMoose
timvw wrote:- And exactly what makes you believe that a webapplication will deliver the reduced look-up time?
He had originally said that:
when someone is trying to get some specific employee information its a problem because there is not a single place to check this information.
That tells me that there is no single storage medium for ALL the data, and his boss's solution is to merely synchronize employee info. My perception of syncing in this manner is just syncing all the data that is the same field, ie names, addresses, not have all the data stored in 1000 places. That would defeat his bosses entire purpose of having it in multiple excel files and access db's.

If you design it properly, and have all the data readily available, how does it not reduce lookup time? Besides, have it stored in multiple locations puts greater strain on a potential backup solution, whereas a single, central db can be backed up easily.

Posted: Wed Jan 10, 2007 3:06 pm
by RobertGonzalez
Keep in mind that you still need to contend with files vs. data. Files are files, and servers have filesystems so files can be managed on the file system. Databases can store files, but they are much better at storing/retrieving/modifying data.

Posted: Wed Jan 10, 2007 3:14 pm
by kingconnections
Also, Excel files that use links and access outside data sources tend to have issues and go corrupt. I worked for a large company and they are always having issues with excel files that are really over grown applications.

Posted: Thu Jan 11, 2007 7:12 pm
by jyhm
Or you could just rip that old bast**d a new one
and say "ridem' cowboy there's a new sherif in town partner!"

Ye Haw! just like, Los vaqueros! :wink:

EDIT: Notice Wink,..