Loading

Some Quick General Questions

BP

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?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Martin van Eerde15y ago
Accepted answer
I don't think there is a physical file size limit, but some applications cannot open a mdf file if it is over a certain size. I think this is 2GB for Access and 4GB for SQL Server Express.

How quickly it grows very much depends on the amount of data being written.

If you have worries about size and speed perhaps you should change to using SQL Server CE.
Karthikeyan Anbarasan15y ago
Go with the relational database like sql. with which u dont need to care about the size... also you can have best performance since connection pooling facilitates as well