Saving the Size of an application

  • Thread starter Thread starter Frank Timmons Jr
  • Start date Start date
F

Frank Timmons Jr

I need some direction here...

I am in the process of developing an Access database that could potentially
contain over 100,000 records, maybe more. This application will strictly be
a read-only database for reporting purposes, not for adding/editing or
deleting data.

Is there anyway I could avoid importing that large amount of data and still
be able to run queries and reports against that data if it's stored in a
..txt file without having to import the data into the application?

If having that much information does not hinder the performance of the
application, then this is a non-issue, but I have a bad feeling that it
will.

Thanks in advance.
 
You can link to text files and then have Access treat the linked files as
tables, but I think you'll get better performance if you actually import the
data into Access tables. AFAIK, there's no way to set indexes on linked text
files, so you won't be able to do searches. 100K records is large, but
certainly nothing Access can't handle.
 
Back
Top