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]

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

vikrant_kpr@hot mail.com (Vikrant) wrote:
[color=blue]
> Can someone please suggest that how many recordset can be opened
>simultaneous ly for a MS-Access 2000 Database.[/color]

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?
[color=blue]
>Does that make any
>difference if we use ODBC or some other way of connecting to the
>database.[/color]

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]

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

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 <ttoews@teluspl anet.net> wrote in message news:<5uaib09qf longkiklp6ni6ot t5g5da0p6p@4ax. com>...[color=blue]
> vikrant_kpr@hot mail.com (Vikrant) wrote:
>[color=green]
> > Can someone please suggest that how many recordset can be opened
> >simultaneous ly for a MS-Access 2000 Database.[/color]
>
> 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?
>[color=green]
> >Does that make any
> >difference if we use ODBC or some other way of connecting to the
> >database.[/color]
>
> You can't use ODBC from an Access FE to connect to an Access BE.
>
> Tony[/color]

[Tony Toews]

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

vikrant_kpr@hot mail.com (Vikrant) wrote:
[color=blue]
>I am planning to use Multiple threads[/color]

In what fashion? Presumable not using Access as the FE.
[color=blue]
>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 ?[/color]

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]

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

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" <vikrant_kpr@ho tmail.com> wrote in message
news:89a2f412.0 405310457.614ea e38@posting.goo gle.com...[color=blue]
> 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 <ttoews@teluspl anet.net> wrote in message[/color]
news:<5uaib09qf longkiklp6ni6ot t5g5da0p6p@4ax. com>...[color=blue][color=green]
> > vikrant_kpr@hot mail.com (Vikrant) wrote:
> >[color=darkred]
> > > Can someone please suggest that how many recordset can be opened
> > >simultaneous ly for a MS-Access 2000 Database.[/color]
> >
> > There is mention of 2048 Table IDs but a query can open many Table IDs[/color][/color]
while it's[color=blue][color=green]
> > processing. Especially during a very complex Union query.
> >
> > What's your specific problem?
> >[color=darkred]
> > >Does that make any
> > >difference if we use ODBC or some other way of connecting to the
> > >database.[/color]
> >
> > You can't use ODBC from an Access FE to connect to an Access BE.
> >
> > Tony[/color][/color]