Results 1 to 4 of 4

Thread: Access and MSDE

  1. #1
    Join Date
    Nov 2003
    Posts
    24

    Unhappy Unanswered: Access and MSDE

    MSDE works fine and i'm able to connect from everywhere i want to, but there is still a little problem in my f* configuration. I'm not able to update or insert any data in the database from MS Access. Using osql or Java with JDBC or any other I'm able to do so, but not in Access.
    Are you able to help me and solve it ?

    thanks dragun

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621

    Re: Access and MSDE

    Originally posted by dragun
    MSDE works fine and i'm able to connect from everywhere i want to, but there is still a little problem in my f* configuration. I'm not able to update or insert any data in the database from MS Access. Using osql or Java with JDBC or any other I'm able to do so, but not in Access.
    Are you able to help me and solve it ?

    thanks dragun
    In past, I had a situation like this - tables on SQL Server (MSDE) did not have primary keys or unique indexes. It sounds stupid but....

  3. #3
    Join Date
    Nov 2003
    Posts
    24
    Ok, it's stupid without any primary key, but i want to know why i can't update any table? I can just read data via access and i need a solution.

    bye

  4. #4
    Join Date
    Dec 2002
    Posts
    1,245
    Access needs a Primary key on the linked table (the table in MSDE). Without it, it cannot issue update or insert commands. Put a Primary Key on your SQL table, re-link the tables in Access and that should do it for you.

    hmscott

Posting Permissions

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