Results 1 to 5 of 5

Thread: Recordset Error

  1. Mar 18th, 2005, 12:33 AM #1
    hyousuf2
    hyousuf2 is offline

    Thread Starter
    Addicted Member hyousuf2's Avatar
    Join Date
    Dec 2004
    Location
    Dublin
    Posts
    226

    Recordset Error

    hi
    i get a run time error '- 2147467259 (80004005)' which says 'method open of object _recordset failed' . i get this error on a particular table, if i change the table name in the query it works fine again, i tried to delete the table and then made it again but same error,
    by the way am using Adodb.Recordset on an Access Database!
    pls help
    Reply With Quote Reply With Quote
  2. Mar 18th, 2005, 12:41 AM #2
    dglienna
    dglienna is offline
    Banned dglienna's Avatar
    Join Date
    Jun 2004
    Location
    Center of it all
    Posts
    17,901

    Re: Recordset Error

    what is the name of the table that you are trying to use?
    Reply With Quote Reply With Quote
  3. Mar 18th, 2005, 01:36 AM #3
    hyousuf2
    hyousuf2 is offline

    Thread Starter
    Addicted Member hyousuf2's Avatar
    Join Date
    Dec 2004
    Location
    Dublin
    Posts
    226

    Re: Recordset Error

    the name of the table is "SaleD" which is the foreign key table of my "SaleM" table but da thing is dat is tried the exact same query in access n it executed perfectly
    Reply With Quote Reply With Quote
  4. Mar 18th, 2005, 01:51 AM #4
    erickwidya
    erickwidya is offline
    Fanatic Member
    Join Date
    Sep 2004
    Location
    Jakarta, Indonesia
    Posts
    818

    Re: Recordset Error

    'method open of object _recordset failed'
    maybe u forgot to set New of the Recordset? or ur SQL Syntax is not right.
    post the code

    1st NF - a table should not contain repeating groups.
    2nd NF - any fields that do not depend fully on the primary key should be moved to another table.
    3rd NF - there should be no dependency between non key fields in same table.
    - E. Petroutsos -

    eRiCk

    A collection of "Laku-abis" Ebook, Permanent Residence

    Access Reserved Words, a Classic Form Bug, Access Limitation, Know run Process and the Lock they hold in, Logging User Activity in MSSQL,
    Kill Database Processes
    Reply With Quote Reply With Quote
  6. Mar 18th, 2005, 02:23 AM #5
    dglienna
    dglienna is offline
    Banned dglienna's Avatar
    Join Date
    Jun 2004
    Location
    Center of it all
    Posts
    17,901

    Re: Recordset Error

    Is it more than one query per recordset? You used the wrong cursor (forward only?)

    I found this:

    http://support.microsoft.com/default...b;en-us;180843
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width