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

Update query not updating

P: n/a
Hi

We have this strange problem on an access 97 app over a network. The backend
db is on a win2003 server and each pc has the front rend linking to the back
end. The app runs an update query which works fine on one pc. On another pc
the query fails and is unable to update the records? Why would this be that
one pc can update the records on the server but not the other? The user
seems to have all the rights as far as I can see.

Thanks

Regards
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
-- Try to update manually. If this succeeds the 'rights' seem to be OK.
-- Try switching frontends also. Are they really the same ?
-- Record-locking ?

--
Hope this helps
Arno R

"John" <Jo**@nospam.infovis.co.uk> schreef in bericht news:42*********************@news-text.dial.pipex.com...
Hi

We have this strange problem on an access 97 app over a network. The backend
db is on a win2003 server and each pc has the front rend linking to the back
end. The app runs an update query which works fine on one pc. On another pc
the query fails and is unable to update the records? Why would this be that
one pc can update the records on the server but not the other? The user
seems to have all the rights as far as I can see.

Thanks

Regards

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.