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@hotmail.com> wrote in message
news:89a2f412.0405310457.614eae38@posting.google.c om...[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@telusplanet.net> wrote in message[/color]
news:<5uaib09qflongkiklp6ni6ott5g5da0p6p@4ax.com>...[color=blue][color=green]
> >
Join Bytes! (Vikrant) wrote:
> >[color=darkred]
> > > Can someone please suggest that how many recordset can be opened
> > >simultaneously 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]
