ODBC data src; Access query

[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

 

[Bryan]

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

 

[Tim Ferguson]

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

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