Append and post - with standardvalues



Howdy all,

In my work with an Access database from Delphi 2007, appending and then posting is straight forward.

However, a few of the values cannot be modified. They raise an "EOleException" with the message (direct translation from the Swedish error message) "The row for updating cannot be found. Some values might have changed since they were last read".

If I close the application (or even closed the database and open it again) then things work fine when I edit them.

I think I have identified the problem to be for fields where I have defined a "default value" (Swedish term is "standard value")

Editing any field with a default value fails with the above error.

Any suggestion what to do?

/Pontus Berg
.



Relevant Pages

  • Re: Partial read-only access
    ... Generally the most straight forward way of doing this is, ... Front End (Forms, queries, code, reports) and Back End ... Nick Coe ... > One of the departments use an Access database that I ...
    (microsoft.public.access.security)
  • RE: Sandbox Mode - Cant Access Access
    ... Please check the references of the Access database to see if there is any ... What is the version (service pack) of the operation system? ... This posting is provided "as is" with no warranties and confers no rights. ...
    (microsoft.public.access.security)
  • Re: FP2003 forms and database
    ... do straight out of the box with FrontPage. ... help if you want them to be in web pages on your web site. ... form with their information from my access database. ...
    (microsoft.public.frontpage.programming)
  • Re: Help please with XML+ASP+RSS
    ... may I apologise for posting to this group. ... > I can create an RSS feed and publish the XML document. ... > I have a MS Access database driving my site with ASP pages. ...
    (microsoft.public.frontpage.programming)
  • Re: database/LabVIEW naming-dependancy blues
    ... This is the reason I like this forum - straight answers when possible and compassion when your code doesn't work:smileysurprised: ... When I use the access database I always stick an autonumber field in ... Queries that read data based on nonindexed fields can become dreadfully slow. ...
    (comp.lang.labview)