Can Access handle it?

  • Thread starter Thread starter Zagor
  • Start date Start date
Z

Zagor

Hi All,
I have a question regarding the capabilities of Access and I would
appreciate any suggestion.

This is the problem:
I need to create a project which upload (monthly) a text file (with
delimiters and so on) to an Access database. The average file size is 50mb
( almost 200.00 records) and each month a new one needs to be appended to
the exiting database. This means that at the end of the year the database
will be roughly 600MB (2.400.000 records).
Can Access handle it?

Thanks in advance
Frank
 
The maximum size of a Jet (MDB) database is 2GB, so at 50 MB per month,
you'd exceed that in about 40 months. If 50 MB is the size of the text file,
that may translate to rather more than 50 MB of Jet data. Try compacting the
MDB, making a note of the size, then importing, then compacting, then
comparing the new size to the old size, to estimate how much the MDB will
grow with each import.

Unless this will be a short-term project with a small number of users, I
think you probably need to be looking at a heavy-duty database engine such
as SQL Server. (Not MSDE, which has the same 2GB limit as Jet).

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Back
Top