Error when updating a view with function field

  • Thread starter Thread starter Hans Merkl
  • Start date Start date
H

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
 
Back
Top