ODBC data src; Access query

  • Thread starter Thread starter David H.
  • Start date Start date
D

David H.

Greetings!

I posted this in the m.p.a.queries newsgroup, but I thought the
knowledgeable folks here could help as well :-)

I've got a linked table in an Access 2K database; the table is linked
to a file on our AS/400.

I can successfully query against the file. However, I've only done
queries that will return a few (10 to 15) records because I'm not sure
of Access's limitations in this area...

I'm wondering if there is a limit to the # of records that can be
returned in an Access query.

For example, if I create a Query whose resulting recordset would be,
let's say , 500-thousand records, is that too much for Access to handle?

What is Access's limit?

Would it be better to use SQL server (or perhaps MySQL)? Would I see a
noticeable increase in performance?


thanks,
David


--


------------------------------
David Hepburn


News for Nerds. Stuff that matters.
http://slashdot.org
 
David,

I am not aware of a record limit for Queries in Access,
although I would think that this would be determined by
the Jet Engine anyways, regardless, I'm pretty confident
that Access can handle up to at least 1 million records.

And yes, you would see much better performance with
MySQL, and even better performance with SQL Server.

Bryan
 
I'm wondering if there is a limit to the # of records that can be
returned in an Access query.
Click to expand...
There's no Access limitation. There may be difficulties if you start
seriously overwhelming your RAM memory capabilities. The server may set a
limit to the number of records returned by a query, which can be overridden
by SQL if necessary (I think..!).

B Wishes


Tim F
 
Back
Top