Some Quick General Questions
I have been working on a vb.net program in visual studio 2008 with a .mdb file. The file will hold two tables: one with roughly 150 rows and 16 columns and the other with about 15,000 rows each with 6 columns. Before I continue, I have some questions about it.
1. I am new to access, but I know it has a size limit. Is a database of this size likely to go over the limit?
2. How much will a large Datatable affect the speed of the program? Is there a Datatable size I should try to stay below?