MS Access capability limitations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, All
I have to upload text file into Access db, total record count up to 2 million,
Is it ok for Access db to handle such amount of records, i need to be able
to manupulate data and print reports from Access.
Please advice,
or i should look for different solution to store data.
 
Elena

Access doesn't have a row limitation so much as row-length and absolute file
size limitations. That's if you use Access/JET to store the data.

How long are your records?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Hi, Jeff
I have to populate the table of 39 fields, the record is 218 bytes (i parse
it into fields). What are the references to Access/Jet ?
When I read this file into db table it takes 30 minutes (DAO),
How to speed up the process?

Please, advice
 
Elena

Given the size (218 bytes) of each record, and your earlier mention of up to
2 million records, if you import this data, you'll be adding in excess of
400 million bytes. Depending on the version of Access, your (theoretical)
limit may be only 1 Gbyte, so you are pressing it. Are you sure you have to
import the data?

Is it necessary to actually import the data into Access, or could you "link"
to the data to do what you're doing?

Access is the product, JET is the database engine that comes in/with Access.
You could also use DB2, SQL-Server, Oracle, dBase, Visual FoxPro, ... and
any number of other "back-end" data stores.

You don't say how you are reading this file into Access, nor into how many
Access tables. You mention DAO, but no code. Have you tried using File |
Get External Data | Import...? If you are trying to stuff "flat-file" data
into a single Access table, you may not be able to make good use of the
features and functions Access offers. Have you normalized your data
structure?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Thank you, Jeff
I have MS Access 2002 with one table which has 39 fields (data type - text,
date/time, currency). All data store in one table, no need for any look up
tables.

I read flat file (fixed lenght record, with no record delimiter) into table
with FileStream.
Our reports were created in MS Access, that is why i have to use Access to
store data.
 
Back
Top