Originally posted by ChrisMI'm sure there's a perfectly sane reason for doing this...but wouldn't it be easier (and somewhat more conventional) to have one db, with column 'IDuser' in each table? Yes of course it would, you've just established that.
It can only get worse: the company does rather well - 5 users becomes 50 - then you have to make some schema changes...
In all fairness, he may not strictly be talking about entire separate databases for each user. He may be talking about user-owned tables in a single database. This is a methodology that does have some distinct advantages. But, again, Crystal does not deal well with changing anything about the connection on the fly.