Re: Sort Question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I think what I am understanding from this is that the records may and
probably are being written in the order they are read (therefore sorted) but
when I open the table for viewing and or exporting, the order they are
displayed has nothing to do with the order they are physically stored in the
table. This actually makes sense to me on one level. It's not that my sorts
aren't working, if I did something like a debug.print after my sort, the
records would print in the right order.

I will take the advice I've received and secure the database and I will also
use the createquerydef method to pass to the export to excel. Do you know
whether I can use a querydef I've created on the fly like this to pass to a
transferspreadsheet method?

Thanks,
m
--
Michal Joyce
Project Management IS Analyst
Aflac - Project Management Office


"David C. Holley" wrote:

> So then there are two dimensions at work - the first being the physical
> organization of the records, which is what is being used when the
> records are put into the new, temporary table and the second which is a
> virtual organziation based on the specified ORDER BY statements.
>
> Marshall Barton wrote:
> > I didn't read the question that way, but the answer to that
> > is the records are stored on disk in whatever way Access (or
> > its programmers) finds convenient. Relational database
> > theory is quite clear on not imposing rules about how data
> > is stored so that database system developers can be free to
> > optimize saving data to the system's advantage.
> >
> > The same applies to retrieving records. The records are
> > only sorted by a query with an Order By clause after the
> > data has been retrived.
>
.

Relevant Pages

  • Re: Open a secure database through code.
    ... the semi-colon at the end of the database name in OpenDatabase is ... Doug Steele, Microsoft Access MVP ... Aflac - Project Management Office ... Set DBdaAgg = Nothing ...
    (microsoft.public.access.modulesdaovba)
  • Re: Open a secure database through code.
    ... Yep - This is the shortcut I use to open the database: ... Michal Joyce ... Aflac - Project Management Office ... Doug Steele, Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: Access or Excel?
    ... These are the sorts of considerations I was ... We currently enter our data into Excel, and pretty much just configure the ... for groups of subjects for particular parameters and at an individual time ... lot of database experience, but a few who are quite proficient with Excel. ...
    (microsoft.public.access.gettingstarted)
  • Re: Error 91 Object Variable or With Black Variable Not Defined
    ... Doug Steele, Microsoft Access MVP ... (no private e-mails, please) ... closing the database I get the Error 91 message. ... Aflac - Project Management Office ...
    (microsoft.public.access.modulesdaovba)
  • Re: how to get the ip address & country of the webpage visitor
    ... That might be a question of the accuracy of the database, ... keep in mind that there are proxy servers and other sorts of ... to the home office? ... convinced the appropriate ISP/telecom companies to do the appropriate ...
    (microsoft.public.dotnet.framework.aspnet)