Error when updating a view with function field

[Hans Merkl]

Hi,

I have started using SQL server instead Access as database backend and I am
running into this problem:

I have a view like this:

SELECT TOP 100 PERCENT id_transaction_type, Description, id_account,
Amount, TheDate, id_account_transaction,
dbo.AccountBalanceAtDate(id_account,
TheDate) AS accountbalance
FROM dbo.TAccountTransactions
ORDER BY TheDate DESC


AccountBalanceAtDate is a user-defined function

I have based an Access form on this view. I can add records and delete
records, but when I try to modify a record, I get an error message "This
record has been changed bu another user....." with the options "Save
record", "Copy to clipboard", "Drop changes".

When I run the view in Enterprise manager (or in access) I don't have that
problem. Also no problems when I remove the call to AccountBalanceAtDate.


Any ideas how I can get around this?

Thanks

Hans Merkl

 

[Hans Merkl]

Problem solved: If I include a timestamp field in the view it works fine.