Importing Members from Snitz forum

Post Reply

Page <12

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
PhGp Members Profile Find Members Posts Newbie Joined: 10 May 2005 Status: Offline Points: 6	Post Options Post Reply Quote PhGp Report Post Thanks(0) Quote Reply Posted: 20 May 2005 at 9:50am
	Hi sfd19 & Gullanian, Please disregard my previous statement re: syntax error. I am using AQL statement in access and getting this: Cannot update <field name>; field not updatable. (Error 3113)

PhGp Members Profile Find Members Posts Newbie Joined: 10 May 2005 Status: Offline Points: 6	Post Options Post Reply Quote PhGp Report Post Thanks(0) Quote Reply Posted: 20 May 2005 at 10:58am
	Should I temporarily remove relationships, and change auto number to number, run the statement then return to previous state?

sfd19 Members Profile Find Members Posts Senior Member Joined: 20 December 2004 Status: Offline Points: 263	Post Options Post Reply Quote sfd19 Report Post Thanks(0) Quote Reply Posted: 20 May 2005 at 2:05pm
	No, do not remove relationships or change fields! You are using a wrong query, it must be: UPDATE tblThread set Author_ID=100 WHERE Author_ID=2 The query you are using is trying to update the Author_ID in tblAuthor, that is not possible. Also it is not required. Run a similar query against all tables where Author_ID gets used (except for tblAuthor), remind you that it does not always have the name 'Author_ID'. For example in tblPMMessage the 'From_ID' stores Author_ID's.
	Politics, economy & social issues: StudentsforDemocracy.net

Post Reply	Page <12

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.