Numerical Index creation by Select statement?

Thread View: comp.databases.ms-access

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Elf Sternberg Mon, 31 Jan 1994 21:26

#103

Author: Elf Sternberg
Date: Mon, 31 Jan 1994 21:26

14 lines
1458 bytes

	I'm tearing my hair out!  Due to memory restrictions in Visual
Basic, I need to be bale to access 'pages' of Snapshots and Dynasets,
rather than reel the entire thing in at once onto a display.  Is there a
way to issue and ORDER BY, and then get, say, records (rows) 1 through
1000, then 1001 by 2000?  Is there a way, in ms-access, to locate the
numerical order by which a Snapshot, Dynaset, or Table is currently
indexed?

		Elf !!!
--
PC Bulletin: Henceforth, sentient computers would like to be known as
"Silicon Intelligences."  "Artificial Intelligence" is a pejorative term
invented by humans based on the mistaken belief that computers are some-
how not "natural."                                     - elf@halcyon.com

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads