ms-access97 & sql server2005
two tables
tblItem
tblItemFeature

form frmItem contains subform frmItemFeature
each form is based on their respective table

creating new record and filling in two bound fields works fine

creating new record, filling in first field, filling in field in
subform and filling in second field, produces error
the data has been changed
another user edited this record and saved the changes before you
attempted to save your changes
reedit the record


both tables have a timestamp fields, per other discussions in this
news group

and the above sequence that causes the error works fine if using a
backend mdb instead of link tables to sql server2005

before the error occurs, neither the form nor the subform is dirty
once the error message box is displayed, I click on 'ok', and then I
can fill in the second field

the same happens with an existing record on the main record and
changing an existing / adding a new subform record

what else could be causing the problem ?

what else can I check ?

On Feb 25, 3:45*pm, Roger <lesperan... (AT) natpro (DOT) com> wrote:
if I go to the subform control on the main form and I add 'me.refresh'
to its exit event, I don't get the error
why ?

Roger wrote:
Either table have triggers on them?

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

On Feb 25, 4:56*pm, "Rick Brandt" <rickbran... (AT) hotmail (DOT) com> wrote:
nope
I just used the access wizard to export the design / data from the mdb
to sql server
nothing else

Roger wrote:
What datatype (on the server) are the fields in the primary keys? If these
don't have exact Access equivelants then it can sometimes round them and get
confused. I doubt that would have if you exported them from with the
wizard, but it's still worth checking.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

"Rick Brandt" <rickbrandt2 (AT) hotmail (DOT) com> wrote in news:BAIwj.14064$R84.12182
@newssvr25.news.prodigy.net:

That wasn't Roger that was Roy.

"lyle fairfield" <lylefa1r (AT) yah00 (DOT) ca> wrote

Which picture was that in, Lyle? Must have been interesting to see Trigger
on Roy. In all the pictures I remember, it was Roy on Trigger.

Larry

"Larry Linson" <bouncer (AT) localhost (DOT) not> wrote in
news:iLJwj.23177$6h7.1226@trnddc04:

Revenge of the Palomino!

I'll have to look for that one in the cheap DVD bin at my local Wal-Mart.

I thought it was such a shame that they wouldn't comply with Roy's request
that when he died, they should stuff him and sit him on top of Trigger in
the museum. If I'm not mis-remembering, though, I think they shut down the
museum after Dale passed on to that Great Range in the Sky.

Larry

lyle fairfield <lylefa1r (AT) yah00 (DOT) ca> wrote:

<guffaw>

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/