How many recordset can be opened simultaneously for a MS-Access 2000 Database

[Vikrant]

Hey friends
Can someone please suggest that how many recordset can be opened
simultaneously for a MS-Access 2000 Database.Does that make any
difference if we use ODBC or some other way of connecting to the
database.

[Tony Toews]

vi*********@hotmail.com (Vikrant) wrote:

Can someone please suggest that how many recordset can be opened
simultaneously for a MS-Access 2000 Database.
There is mention of 2048 Table IDs but a query can open many Table IDs while it's
processing. Especially during a very complex Union query.

What's your specific problem?
Does that make any
difference if we use ODBC or some other way of connecting to the
database.

You can't use ODBC from an Access FE to connect to an Access BE.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

[Vikrant]

I am planning to use Multiple threads
each of which will add some record to the common database
Now i wish to know that how many such recordsets can be created
ie how many simultaneous Recordsets i can open

or i should opt for MSDE ?
and any idea about MSDE ?

Tony Toews <tt****@telusplanet.net> wrote in message news:<5u********************************@4ax.com>. ..

vi*********@hotmail.com (Vikrant) wrote:

Can someone please suggest that how many recordset can be opened
simultaneously for a MS-Access 2000 Database.

There is mention of 2048 Table IDs but a query can open many Table IDs while it's
processing. Especially during a very complex Union query.

What's your specific problem?

Does that make any
difference if we use ODBC or some other way of connecting to the
database.

You can't use ODBC from an Access FE to connect to an Access BE.

Tony

[Tony Toews]

vi*********@hotmail.com (Vikrant) wrote:

I am planning to use Multiple threads
In what fashion? Presumable not using Access as the FE.
each of which will add some record to the common database
Now i wish to know that how many such recordsets can be created
ie how many simultaneous Recordsets i can open

or i should opt for MSDE ?
and any idea about MSDE ?

If you think you will be nearing Access limits then MSDE is something to consider.
Note that MSDE supports only five simultaneuous processes. Which is not the same as
five users.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

[david epsom dot com dot au]

If you do it correctly, MS Access 2000 does not
limit AT ALL the number of recordsets you can have
open. It is tracked and counted ONLY by the file
system on the computer where the database is stored.

There will eventually be a limit to the number of
file locks that your server can support.

Because I have never heard of anyone reaching this
limit using an Access 2000 database on a Windows 2000
server, I expect that you will find other problems
before you find that your server can not support
any more open recordsets.

(david)

"Vikrant" <vi*********@hotmail.com> wrote in message
news:89**************************@posting.google.c om...

I am planning to use Multiple threads
each of which will add some record to the common database
Now i wish to know that how many such recordsets can be created
ie how many simultaneous Recordsets i can open

or i should opt for MSDE ?
and any idea about MSDE ?

Tony Toews <tt****@telusplanet.net> wrote in message

news:<5u********************************@4ax.com>. ..

vi*********@hotmail.com (Vikrant) wrote:

Can someone please suggest that how many recordset can be opened
simultaneously for a MS-Access 2000 Database.

There is mention of 2048 Table IDs but a query can open many Table IDs while it's processing. Especially during a very complex Union query.

What's your specific problem?

Does that make any
difference if we use ODBC or some other way of connecting to the
database.

You can't use ODBC from an Access FE to connect to an Access BE.

Tony