Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Location
    California
    Posts
    1

    Unhappy Unanswered: Method Connection of Object '_CurrentProject' failed

    I am getting this message when I am opening a connection object. All that I did was as follows:

    Dim con as new ADODB.Connection
    Dim rs as new ADODB.recordset

    set con = CurrentProject.Connection

    At that point Iam getting this error
    Method Connection of Object '_CurrentProject' failed

    Could anyone help me with this please!! I need to resolve this problem as quickly as possible. Thanks for your help.

  2. #2
    Join Date
    Oct 2003
    Posts
    1

    Re: Method Connection of Object '_CurrentProject' failed

    I am a new access user, and getting this same error. I can't see the replies to your thread. Can you tell me how you solved it?

    thanks,
    kelly

    Originally posted by Sirisha
    I am getting this message when I am opening a connection object. All that I did was as follows:

    Dim con as new ADODB.Connection
    Dim rs as new ADODB.recordset

    set con = CurrentProject.Connection

    At that point Iam getting this error
    Method Connection of Object '_CurrentProject' failed

    Could anyone help me with this please!! I need to resolve this problem as quickly as possible. Thanks for your help.

Posting Permissions

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