Post reply

Access to modify a table via Access

  • May 25, 2004 at 9:57 pm

    #65901

    This is a bit of a funny one.....I have a user which is granted access to a database via an alias. The aliased user can modify the data in tables via Enterprise manager, but attempting to modify some tables fails when attempting to do the same update in Access. The user is aliased to a 'dbo' user so there should be no trouble updating the records.

    Any suggestions would be much appreciated.

    Regards,

    Terry

  • May 27, 2004 at 1:50 am

    #507957

    Does the Table have a Primary Key?

    I have fallen for this myself. EM will let you modify data directly regardless of there being a primary key (as long as you are not trying to update one of a pair of duplicate records!) In access if you try and alter a record in a table that does not have a primary key you will notice a message (bottom left of the form) that states record set is not updateable or something along these lines.

     

    Karl

  • May 27, 2004 at 3:27 am

    #507968

    take care to refesh the tables in Access after you make modification on SQL SERVER.

    also take care of filling all field in access that is required


    Alamir Mohamed
    Alamir_mohamed@yahoo.com

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

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