Adding "New" records with Views

• BlairA

  Newbie

  Points: 9

  More actions

  December 12, 2002 at 1:57 pm

  #101330

  I would like to add new records to a sql 2000 database with a view and without granting Select permissions to the SQL table.

  The View is part of a small Microsoft Access 2000 Project file. I am unable to return the blank "new record" in the View unless I have "Select" permission on the table.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 739010

  More actions

  December 12, 2002 at 5:10 pm

  #444305

  Probably an Access issue. Not sure you can get around this.

  Maybe make a blank duplicate table and when you do the insert, copy the data to the real table and delete it from the dup table.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones