Linking sql server 2000 table disables 'new record addition' butto

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

I am trying to link a table in sql server 2000 in MS access 2000.
But when I create a form using this table. All the navigation buttons are enabled except for new record addition button. Why can't I add new records to this table through access? What can I do to enable this button?

Thanks in advance
 
One of two things could be going on.
1) Your form has the property Allow Additions set to No, change this to yes.
2) You do not have permissions to add records to the table. If you open the table from the tables tab is the new record button enabled there? If not, step one will probably not help and you will need to make sure that your ID has permission to add data to the SQL table.
 
Back
Top