Data Entry

[Guest]

MS Access 2002 front end and MS SQL Server 2000 as back end. The user is
dbowner in the database but using MS access she can not update fields in
tables or using forms. I am puzzled because in the menu toolbar under
records > Data entry is completely grayed out. I am sure this is the problem
but can't find a way to change it and update records using MS Access. Thank
in advnace for your help.

Good day

 

[Rick Brandt]

MS Access 2002 front end and MS SQL Server 2000 as back end. The
user is dbowner in the database but using MS access she can not
update fields in tables or using forms. I am puzzled because in the
menu toolbar under records > Data entry is completely grayed out. I
am sure this is the problem but can't find a way to change it and
update records using MS Access. Thank in advnace for your help.

Good day

Does the table have a primary key defined on the server? If not then the
link you created will be read only.

 

[Guest]

Thanks Rick, it did not have PK and as soon as I created the PK we were able
to update the data using MS Access. I appreciate you quick response.

Good day,

 

[John W. Vinson]

MS Access 2002 front end and MS SQL Server 2000 as back end. The user is
dbowner in the database but using MS access she can not update fields in
tables or using forms. I am puzzled because in the menu toolbar under
records > Data entry is completely grayed out. I am sure this is the problem
but can't find a way to change it and update records using MS Access. Thank
in advnace for your help.

Good day

In order to update SQL tables from Access, you must have a Primary Key defined
on the SQL table, and Access needs to know which field that is (it's an option
when you first link to the SQL table).

There are other possible reasons but this is the first that comes to mind!

John W. Vinson [MVP]