can't save more record in one go

Results 1 to 2 of 2

Thread: can't save more record in one go

  1. #1
    Join Date
    Dec 1969
    Posts
    56

    Default can't save more record in one go

    I wish to save 1000 records into a MS Access DB using asp on the web. Every time I got 63 records saved and got the following error message:<BR>"Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e4d&#039 <BR>[Microsoft][ODBC Microsoft Access Driver] Too many client tasks."<BR>I&#039ve considered the curser type and locking type to fast the speed, but it is still not work. Any suggestions about it? <BR>thanks a lot ! !<BR>

  2. #2
    Join Date
    Dec 1969
    Posts
    2,849

    Default RE: can't save more record in one go

    What code are you using? Access only supports 64 current connections. Are you using a new Connection object for each statement? Let us see your code... :-)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •