Thread: ODBC Error
View Single Post
  #7   Report Post  
Jamie Collins
 
Posts: n/a
Default


Dkline wrote:
I'm guesssing that the limit is around 20 or 21 sessions at the same


time.


I'd merely be guessing too. Documentation on the inner workings of
MSQuery seem to be non-existent. When using ADO I know how many
connections I've opened, usually just one.

Remember the .mdb will have a limit to the number of concurrent
connections i.e. a theoretical limit of 255 (assuming the .ldb has
cleared successfully) but I've been told the 'safe' limit is more like
10.

Jamie.

--