You have to keep in mind that each record has to be sent accross the wire via TCP/IP and it is going to take a lot of time to bring back 1 million rows and I am sure your network admin would notice increased network traffic.
In a real application you would use something like the Delphi Tdataset based components which will only bring back the records that can be seen on the screen, then when you scroll, it brings back more.
you can manually create something like this using Postgresql handy LIMIT and OFFSET sql keywords in your query to build a paging system.
Access is actually a very poor choice for client/server application development, like I said before, invest some time learning Delphi, it's not difficult at all and you won't have these problems.
You can get a copy of Delphi 7 personal edition and you can use the zeos components with it. http://www.zeoslib.net
Tony
.
When I had it loop and add 1000 rows, it was ok... When I told it to add a million rows.... then after 250,000 the Access application hung (but not the whole machine, and not the
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
