Can't delete record in linked SQLServer table.

M

MichaelK

It happens in both Access2000 and Access97.
When I open in Access the table, linked from SQL Server,
I can't delete any records or update any field in the record
if the DateEntry field has the formula GetDate().

If try to delete the message is: "The Microsoft Jet database engine stopped
the process because
you and another user are attempting to change the same data at the same
time."

If try to change a field (not the DateEntry ofcourse) the message is:
"The data has been changed. Another user edited this record and saved
before you attempting to save your changes."

Nobody else using this table, I just created it and nobody knows about it,
permissions are set to delete.
If I remove the formula from the field in SQL Server and relink it, delete
working fine again.

What should I do to have a formuls and be able to delete records?

Thanks,
Michael
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Naming of Form Button 3
Doughnut Chart linked with the slicer in the pivot table 0
Copy previous record into form field 0
Linked SQL Tables don't report Cascading Updates and Deletes 2
Autonumber field in Excel that behaves the same as Access 0
Dealing with a Pivot Table (when I don't want to) 0
Linked Views to SQLServer become Read-Only 0
Linked Table Cant Delete Record 2

Top