By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,650 Members | 1,996 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,650 IT Pros & Developers. It's quick & easy.

ms-access97 & sql server2005 - error "the data has been changed"

P: n/a
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 ?
Feb 25 '08 #1
Share this Question
Share on Google+
10 Replies


P: n/a
On Feb 25, 3:45*pm, Roger <lesperan...@natpro.comwrote:
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 ?
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 ?
Feb 25 '08 #2

P: n/a
Roger wrote:
On Feb 25, 3:45 pm, Roger <lesperan...@natpro.comwrote:
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 ?
Either table have triggers on them?

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Feb 26 '08 #3

P: n/a
"Rick Brandt" <ri*********@hotmail.comwrote in news:BAIwj.14064$R84.12182
@newssvr25.news.prodigy.net:
Roger wrote:
>On Feb 25, 3:45 pm, Roger <lesperan...@natpro.comwrote:
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 ?

Either table have triggers on them?
That wasn't Roger that was Roy.
Feb 26 '08 #4

P: n/a
"lyle fairfield" <ly******@yah00.cawrote
>Either table have triggers on them?

That wasn't Roger that was Roy.
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
Feb 26 '08 #5

P: n/a
"Larry Linson" <bo*****@localhost.notwrote in
news:iLJwj.23177$6h7.1226@trnddc04:
"lyle fairfield" <ly******@yah00.cawrote
Either table have triggers on them?
That wasn't Roger that was Roy.

Which picture was that in, Lyle?
Revenge of the Palomino!
Feb 26 '08 #6

P: n/a
lyle fairfield <ly******@yah00.cawrote:
>Either table have triggers on them?

That wasn't Roger that was Roy.

Which picture was that in, Lyle?

Revenge of the Palomino!
<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/
Feb 26 '08 #7

P: n/a
Roger <le*********@natpro.comwrote:
>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
Just guessing. Is the primary key of those tables also on the form?

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/
Feb 26 '08 #8

P: n/a
"Tony Toews [MVP]" <tt****@telusplanet.netwrote in
news:9n********************************@4ax.com:
lyle fairfield <ly******@yah00.cawrote:
>>Either table have triggers on them?

That wasn't Roger that was Roy.

Which picture was that in, Lyle?

Revenge of the Palomino!

<guffaw>

Tony
I'm back in my childhood cowboy days and Tony never said <guffawthen,
only <neighor <whinny>.

I guess we'll see if there's anyone here who's familar enough with the
radio cowboys of the early 40's to know why.

Here's a hint. I listened to a show with Tony in it from 17:45 to 18:00
(5:45 pm to 6:00 pm) from WSLB, Ogdensburg every afternoon in 1945 and on
April 12 it was interrupted by a famous announcement. My friend, Donald and
I went out onto the street to tell people this news but no one believed
seven year olds. We should have said, "But it's true, man (or soon will
be)!"

And some people say there's nothing new to be learned on CDMA!

Lyle
(Always the Lone Ranger)

Feb 26 '08 #9

P: n/a
"lyle fairfield" <ly******@yah00.cawrote
I'm back in my childhood cowboy days and Tony
never said <guffawthen,
only <neighor <whinny>.

I guess we'll see if there's anyone here who's familar enough with the
radio cowboys of the early 40's to know why.

Here's a hint. I listened to a show with Tony in it from 17:45 to 18:00
(5:45 pm to 6:00 pm) from WSLB, Ogdensburg every afternoon in 1945 and on
April 12 it was interrupted by a famous announcement. My friend, Donald
and
I went out onto the street to tell people this news but no one believed
seven year olds. We should have said, "But it's true, man (or soon will
be)!"

And some people say there's nothing new to be learned on CDMA!
I remember listening to that same show, never realizing that both Tony and
his master were both gone on to the Great Beyond by then. And, going on to
the Great Beyond might be a good lead-in to the other event you mentioned.
Feb 26 '08 #10

P: n/a
On Feb 25, 9:52*pm, "Tony Toews [MVP]" <tto...@telusplanet.netwrote:
Roger <lesperan...@natpro.comwrote:
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

Just guessing. *Is the primary key of those tables also on the form?

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 athttp://www.granite.ab.ca/accsmstr.htm
* *Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/- Hidequoted text -

- Show quoted text -
yes.. all fields that make up the primary keys of both tables are on
the forms
Feb 26 '08 #11

This discussion thread is closed

Replies have been disabled for this discussion.