>>>AFAIK, MSDE is limited with 2GIG.
>>
>>and that's not per table, right? If it works like SQL, there's one big file.
>
>SQL Server 7.0 does not store the data in one big file. Each table is in it's
own file. The MSDE limit is per database.

I thought this was to be the case when moving from 6.5 to 7.0, but I have yet to see it. The only way I can tell to actually get separate files for each table is to create the database and specify one filegroup file per table, then create each table on its filegroup file.

If you create a database and create its tables without specifying separate filegroups, you still get two files. The database is one file, and the transaction log is in another.

From SQL 7.0 Books online:

A database consists of two or more files: one data file to hold tables and other objects, and another file to hold the transaction log. Each file is used by only one database. A single file cannot be shared by multiple databases. When a database is dropped, its files are also deleted. Note that you can detach a database to preserve the files, rather than only to drop a database.