Quote Originally Posted by si_the_geek View Post
Thread moved to the 'Database Development' forum (the 'VB6' forum is only meant for questions which don't fit in more specific forums)


It sounds like an Access based database is not right for you (the theoretical maximum size is 2GB, but anything over 1GB is likely to fail), you may be better off using SQL Server Express (maximum 10GB per database, safely) or similar.


The fact you think you want more than 50 fields in a table also makes it seem that you don't really understand databases, because it is unusual to have more than 20 fields per table - and usually when we see people wanting more than that, it is so that fields can be duplicated (eg: Name1, Name2, etc), which is not what you should be doing.

If you explain to us why you think you want that many fields (and what information you are actually going to be storing), we can give you appropriate advice.
Greetings si_the_geek,

Thanks for moving this topic to a more appropriate place.

I made several comparisons between Access, SSEx, SQLite and all have some basic differences and limitations. But like a classic Tower of Babel.

The reasons why I want a database so complex, you can see on # 13.

Thank you and good coding.