Edit SQL Server table in an Access 2003 subform

I have a subform with a linked SQL Server table as its RecordSource. I am not using the Link Child Fields and Link Master Fields properties. When I edit the record in the subform I get the msg "This record has been changed by another user, etc." with the Copy to Clipboard ad Drop Changes buttons. How do I edit this SQL Server table without getting that message? Thanks
paulmcneilAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Gustav BrockCIOCommented:
You have some other process or function that has updated the data since you opened the form. Change that.

/gustav
0
paulmcneilAuthor Commented:
No I do not have another process going on
0
Gustav BrockCIOCommented:
Look again. This will not happen if not "something" and "something else" has or is updating the same table.

/gustav
0
paulmcneilAuthor Commented:
I decided to load my data into local temo tabels for editing with the subforms to get rid of the Copy to Clipboard msg
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
paulmcneilAuthor Commented:
I decided to use another method to edit
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.