MS Access Multiuser - Locked Record

Author

Locked Record

David W

2005-07-10, 8:24 pm

I have got 2 applications that use the same dbf. The first one uses all
fields except for one field called "status", it will never use that field
for any reason other than looking at the value in it. The second application
only uses that one field called "status", but views the other fields.

The problem I get when I run through my code that loops through the field
that changes the value in "status" is an error that says "the value has
changed". Is this a record locking issue, if its is, is thier away to get
around the error.

I am not changing the information that the other app uses, I added this
field to modify from the second app. and I really do need to get this value
in that field to evaluate things from within the first app.

Thanks David

By Chanthorn

2005-08-20, 3:24 am

Hi there,

You can used Rs=DB. Openrecordset(sql,Db
ReadOnly)
Hope can help!
--
By Chanthorn

"David W" < davidw@mcintoshconst
ruction.net> wrote in message
news:usFd0yYhFHA.3316@TK2MSFTNGP14.phx.gbl...
> I have got 2 applications that use the same dbf. The first one uses all
> fields except for one field called "status", it will never use that field
> for any reason other than looking at the value in it. The second
application
> only uses that one field called "status", but views the other fields.
>
> The problem I get when I run through my code that loops through the field
> that changes the value in "status" is an error that says "the value has
> changed". Is this a record locking issue, if its is, is thier away to get
> around the error.
>
> I am not changing the information that the other app uses, I added this
> field to modify from the second app. and I really do need to get this
value

> in that field to evaluate things from within the first app.
>
> Thanks David
>
>

Sponsored Links