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!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do you sort a LINKED table with many records?

Status
Not open for further replies.
christheprogrammer

christheprogrammer

Programmer
Jul 10, 2000
258
CA
What I want to do is rst.index = &quot;THE_INDEX&quot; but this can only be done on table-type recordsets.&nbsp;&nbsp;Does anyone know how to accomplish this same feat for linked tables?&nbsp;&nbsp;I have over 3,000,000 records in each table, so importing the tables is not an option ( i wish it were).&nbsp;&nbsp;Also I cannot do a seek everytime or I will be here for 10 years (I actually calculated it out)&nbsp;&nbsp;Thanks everyone<br>Chris
 
Status
Not open for further replies.

Similar threads

ameedoo3000
  • Locked
  • Question
Clear all table contents without deleting records
Replies
15
Views
1K
ameedoo3000
ameedoo3000
YoBi4Ever
  • Locked
  • Question
I would like to compute how many minutes or hours the employee left work by comparing two records
Replies
3
Views
383
dhookom
dhookom
A
  • Locked
  • Question
Print Table attachment
Replies
2
Views
318
andre.meyer
A
OCM
  • Locked
  • Question
Populate access table from excel
Replies
6
Views
5K
OCM
OCM
renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
988
renigar
renigar

Part and Inventory Search

Sponsor

Back
Top