 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Importing / Linking / November 2004Can Access handle it?
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).  SignatureBrendan 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. > Hi All, > I have a question regarding the capabilities of Access and I would [quoted text clipped - 10 lines] > Thanks in advance > Frank |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.