Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2002
    Location
    Baton Rouge
    Posts
    6

    Unanswered: linkd tbl sql,error/headache!

    I have this database that connects to a SQL server via linked tables(ODBC), the database is mainly for reports, but its does have to insert records to the sql server, I started getting the error that tells me to use dbSeeUpdates, and so I started using it and now all I get is Invalid Argument, Here is the line of code.

    Set myrs = mydb.OpenRecordset("tblPayables", dbOpenTable, dbSeeChanges, dbOptimisticBatch)


    Any one have any Idea what I am doign wrong?

  2. #2
    Join Date
    Jun 2002
    Location
    Baton Rouge
    Posts
    6
    does anyone have any suggestions on this?

  3. #3
    Join Date
    Oct 2001
    Location
    Bay Area, CA
    Posts
    117
    I don't recognize the error.
    Perhaps you can post the exact error for people to help you.

    Can you update records in the SQL Server table (from Access) directly?

Posting Permissions

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