Hi,
I'm using log file as source file for my access querie. Log file contains a
lot of information and it is bigger than 10 MB (queie needs 5+ sec for final
result).

How can setup querie that it search just first 1000 lines of log file?
(there is more than 40.000 lines).

Thnx!

5 seconds sounds VERY much to long of time for such a small file.

Does the have a index on it?

If the file has autonumber id, then to get the last 1000 records, try:

select top 1000 * from tblMainClient order by id desc


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)