Access Link to SQL not updating

I have an SQL database with an old Access Front end.
I have linked the tables into access.
The first 6k or so records are updatable.
All new records are not updatable from Access.
I can update them via the enterprise manager.
I am using an ODBC connection as sa. So I feel that there shouldn't be a
security issue.
The error I get when trying to update newer records is the record locking
msgbox that saves save/copy/drop
But save is grey'd out.
I have an identity field as the primary key so I don't think theres a
problem with the uniqueness of the records.
Is that enough information?
"trevogre" <trevogre@.discussions.microsoft.com> wrote in message
news:7A35E963-030B-4431-822F-FA4C64571FB9@.microsoft.com...
> I have an SQL database with an old Access Front end.
> I have linked the tables into access.
> The first 6k or so records are updatable.
> All new records are not updatable from Access.
> I can update them via the enterprise manager.
> I am using an ODBC connection as sa. So I feel that there shouldn't be a
> security issue.
> The error I get when trying to update newer records is the record locking
> msgbox that saves save/copy/drop
> But save is grey'd out.
> I have an identity field as the primary key so I don't think theres a
> problem with the uniqueness of the records.
> Is that enough information?
Try adding a column to your table of datatype TimeStamp and re-link your
table from Access. Also, be sure to update your copy of Jet with the latest
Jet service pack.
Steve