Is it better to have all files in one database?

[hartmut77]

I am working on a database which had about 20 files in earlier versions. I am wanting to put it all in one database as 20 tables. Is there any reason not to?

[hartmut77]

I also will be using this solution on a network with 10 users. So I wanted to mention that.

[jfmcel]

You might want to separate your data from your interface -- 20 files to two files. This will allow for off-line development and easier upgrades.