User Profile

Collapse

Profile Sidebar

Collapse
tgit
tgit
Last Activity: Nov 22 '07, 03:10 AM
Joined: Nov 21 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • tgit
    replied to runtime error '-2147467259 (80004005)'
    in Visual Basic
    The issue was due to linked table. ODBC connection was required to be set again at new machine.

    I did that and it worked just fine.

    Thanks Veena for your help . And yes, upper quote ( ' ) works fine in query.

    Regards,
    TG
    See more | Go to post

      Leave a comment:

    • tgit
      replied to runtime error '-2147467259 (80004005)'
      in Visual Basic
      Veena, Using '#' does not solve problem.


      Any other thoughts?

      Thanks,
      TG
      See more | Go to post

        Leave a comment:

      • tgit
        replied to runtime error '-2147467259 (80004005)'
        in Visual Basic
        Thanks a lot for your reply Veena

        Could you let me know why '#' does work instead of upper quote ( ' )?

        Thanks
        TG
        See more | Go to post

          Leave a comment:

        • tgit
          replied to runtime error '-2147467259 (80004005)'
          in Visual Basic
          Hi,
          Code below:
          Code:
          Set conn = Application.CurrentProject.Connection
            Set cmd = New ADODB.Command
            cmd.ActiveConnection = conn
            
            strQuery = "INSERT INTO DETAILED_TRANSACTION ( TRANSACTION_ID, CARD_NUMBER, TRANSACTION_DATE, TRANSACTION_TIME, WHERE_NAME ) " & _
                       "SELECT [TxnID] AS TRANSACTION_ID, [CARDNUMBER] AS CARD_NUMBER,
          ...
          See more | Go to post
          Last edited by tgit; Nov 21 '07, 07:49 AM. Reason: forgot to add comment

            Leave a comment:

          • tgit
            started a topic runtime error '-2147467259 (80004005)'
            in Visual Basic

            runtime error '-2147467259 (80004005)'

            Hi,
            I have moved application from windows 2000 to xp platform. I am using Access 2003.

            I am getting the error during a insert operation on table.

            Error:
            runtime error '-2147467259)'
            ODBC connection to 'Employeesystem ' failed.

            Curious point is that delete operation on table is working fine.

            Any thoughts on how to resolve this error?

            Thanks
            TG
            See more | Go to post
            No activity results to display
            Show More
            Working...