A little advice on tables or files?
Quick question.. traditionally I've built a new table for each element of what I'm doing. I've had a client ask me to build a system for them and I've been looking at alternative routes.
He currently has three indivual Access files - one for Customer details, one for Support Details and the other for Products. They've asked me to create a central system which makes sense.
I could create one file with three tables in it or I could create three files and then one 'central' file which pulls the data together.
If one of the files ever corrupted, the system won't fall over, same can't be said of the tables route.
Anyone any suggestions on the pros and cons?