[RESOLVED] Another DB choice thread... mdb vs accdb or something else?

[QuagmireMan]

I am developing a program that is looking at a Local db every few seconds with approx 10,000 enteries per table (it will only be looking at one table at a time)

also I might be using the some of the terms incorrectly... feel free to correct me.

Is there any reason to go with the accdb format (Access 2007) over the mdb format?


Also is it better to have multiple db files, or a single db with many tables?
(I am concerned with problems from opening and closing multiple db files...)


Thanks
-Qman

[GaryMazzone]

Single db with many tables. Don't even think of many dbs of a single table each. What will the size be for the total database that might drive consideration of which database also

[QuagmireMan]

there will be 200 - 500 seperate tables
with no more than 10,000 rows each.

but I am talking about have 5 files for 5 different routines in my program. Or would you still go with a single db file?

[GaryMazzone]

Single database. The choice of database will depend on the size the database can get to. I have issues with Access about 500 meg. When it gets that size I suggest SQLExpress

[QuagmireMan]

is there a way to calculate estimated size of a table before I build it?

[GaryMazzone]

Sure how many rows in the table * the size of a row. The size of a row can be calculated by looking at the size of the field for the table. As an example

We have table1 columns FName Text (or Varchar) 20, LName Text 30, AddressLine1 Text 50, AddressLine2 Text50 AddressLine3 Text 50, City Text 20, State Text 2, ZipCode Text 10 PK Int

This adds up to 20 + 30 + 50 + 50 + 50 + 20 + 2 + 10 + 4 * the number of rows exptected in the table (rough only)

[QuagmireMan]

is that (20 + 30 + 50 + 50 + 50 + 20 + 2 + 10 + 4) bytes?

[GaryMazzone]

yes.

[QuagmireMan]

Great! Thanks a ton!