Results 1 to 2 of 2

Thread: Getting very annoyed with ODBC!!!

  1. #1

    Thread Starter
    Member
    Join Date
    Aug 2000
    Posts
    35

    Angry

    I am using the DBase 4.00 ODBC driver to connect to a DBase5 table. I am using ADO. This is how I open the table.

    conDbase.ConnectionString = "Data Source = DBaseSys"

    conDbase.Open

    recDbase.Open "Select * from TBLCUST", _
    conDbase, adOpenKeyset, adLockOptimistic

    When I try to make changed it tells me

    [ODBC driver] Cannot Update. Database or object is read-only.

    The same code works fine if I am using a Access table and ODBC driver. What the dilly-yo?

  2. #2
    Serge's Avatar
    Join Date
    Feb 1999
    Location
    Scottsdale, Arizona, USA
    Posts
    2,744
    It can mean that you don't have permissions to update the database.Check wih the database administrator (if one exists).

Posting Permissions

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



Click Here to Expand Forum to Full Width