choosing a database

[Indi]

Hi All

I need to import and save about 15000 records into a database on a daily basis. I might need to do this for about 6 months...
can Access handle this number?

I have another app that works with 300Megs access database file and still works okay! Any of you Gurus cam across a limit on access database file size?

Thanks Much!

[Indi]

Hi All,

I've some more detail if it is needed to help me with my question, each record is 4 numeric field and 2-3 text fields each about 75 chars long.

Could any of you guys help me??

[pclement]

Access has a limitation of 2 GB. If you think that you may exceed that number you may want to consider an MSDE database.

[Indi]

Thank you much Paul. I don't think my db might grow so huge...but if I have to run a small VB app based on it (single user) would it work okay?

[pclement]

Yes, single-user access should be fine from a Visual Basic application. I would recommend compacting the database at least once a week.

[Indi]

Thanks again, Paul.

Happy Holidays!