Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Breaking HUGE file into smaller tables of 4000 records??
- Thread starter ftpdoo
- Start date
dschomburg
MIS
It does seem kind of silly to break it down into multiple tables with the exact same fields. If you did that, you would have to have 3 (or however many) queries on 3 different tables looking for the exact same information.
May I ask why you need the specific # of 4000 records each? Are you having issues with the amount of time it takes to query?
-Dave
May I ask why you need the specific # of 4000 records each? Are you having issues with the amount of time it takes to query?
-Dave
Why? Why? Why?
I've had effective Access databases with over 1,500,000 records in a table (yes, one and a half MILLION records). 80,000 records is not huge, it's small (but not tiny).
As mentioned, use queries to select groups of records (particularly for reports). If you want a form to only view a subset of records, you can put a combo box on the form for the user to select the filter criteria, write the selected criteria into the filter property of the form (once you set the filterOn property to true) and requery the form to select the records of interest.
All you'll do by splitting the table into two or more versions of the same table is to create a monster because exactly the same type of data will be in multiple tables.
If you have a lot of duplicate data in the table, maybe you need to create one or more lookup tables for the common data and just put a reference ID in your main table to link to the reference ID for the appropriate record in the lookup table.
I've had effective Access databases with over 1,500,000 records in a table (yes, one and a half MILLION records). 80,000 records is not huge, it's small (but not tiny).
As mentioned, use queries to select groups of records (particularly for reports). If you want a form to only view a subset of records, you can put a combo box on the form for the user to select the filter criteria, write the selected criteria into the filter property of the form (once you set the filterOn property to true) and requery the form to select the records of interest.
All you'll do by splitting the table into two or more versions of the same table is to create a monster because exactly the same type of data will be in multiple tables.
If you have a lot of duplicate data in the table, maybe you need to create one or more lookup tables for the common data and just put a reference ID in your main table to link to the reference ID for the appropriate record in the lookup table.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
