Numerical Index creation by Select statement?

Article View: comp.databases.ms-access

Article #103

Back to comp.databases.ms-access Previous Next

#103

From: 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

Technical Details

Message-ID: <2ijt1o$fgo@nwfocus.wa.com>

Path: arc1-ca.pugleaf.net!gmd.de!xlink.net!howland.reston.ans.net!cs.utexas.edu!uunet!mdisea!uw-coco!nwnexus!elf

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff0ac,f73a2a028683c00,start
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 11355a,f73a2a028683c00,start
X-Google-Attributes: gid11355a,public
X-Google-ArrivalTime: 1994-02-01 10:16:40 PST
Path: arc1-ca.pugleaf.net!gmd.de!xlink.net!howland.reston.ans.net!cs.utexas.edu!uunet!mdisea!uw-coco!nwnexus!elf
From: elf@halcyon.com (Elf Sternberg)
Newsgroups: comp.databases.ms-access,bit.listserv.sqlinfo
Subject: Numerical Index creation by Select statement?
Date: 31 Jan 1994 13:26:16 -0800
Organization: "A World of Information at your Fingertips"
Lines: 14
Sender: news@nwfocus.wa.com
Message-ID: <2ijt1o$fgo@nwfocus.wa.com>
NNTP-Posting-Host: nwfocus.wa.com