>>>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.

Well, it depends on how you set it up. If you don't specify other options, you get one disk file with all database objects and one log file. IOW yes, normally you get one big file and all tables and other stuff is in it. Log file is always a separate file.