Post reply

unable to add or update records from access

  • July 25, 2005 at 12:57 am

    #165023

    hi,

    i have managed to create an odbc connection from sql serverto access.i am able to view all the tables and views according to the permissions i have set.but i am unable to add or update any records from the access side while i am able to do the same thing on the sql server using the same account.what is the problem?

  • July 25, 2005 at 1:02 am

    #576664

    Forgive me if I am a touch rusty on the Access side of things, but from memory Access opens a read only connection into SQL Server so you wont be able to make or saver any changes in your SQL Server DB via access.

     

    Hope this help....

     

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • July 25, 2005 at 1:58 am

    #576678

    hi,

    i managed to do it.now i can update my recors from the access side using odbc connection.the problem was that unless u specify a primary key u cannot update the records in access.thanx anyway

  • July 26, 2005 at 3:33 pm

    #577329

    Soumna,

    Thanks for posting the solution!

     

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply