Update Query Error !!

[Alpha008]

I'm trying to run an update query but it is returning zero records , i have tried changing the fields the other way round but it does not seem to work , any ideas what the problem is ?

P/s The originating query (Sheet1_OLD)is a dataset which i imported from from excel and in keeping with good data modelling practices created new tables which i wanted the access database to be based on , but it is not working ...heres a snapshot of the SQL :

UPDATE Sheet1_OLD, Location INNER JOIN (tblDepartment INNER JOIN Asset ON tblDepartment.Dep_ID = Asset.Dept_ID) ON Location.Desk_pos = tblDepartment.Desk_pos SET Location.Podname = [Sheet1_OLD]![Podname], Location.Desk_pos = [Sheet1_OLD]![Deskposition], Asset.Tel_Ext = [Sheet1_OLD]![Extension], tblDepartment.Dept_name = [Sheet1_OLD]![Department], Asset.Tel_port = [Sheet1_OLD]![Tel Port], Asset.Comp_port = [Sheet1_OLD]![Comp Port], Asset.Comp_Build = [Sheet1_OLD]![Comp Build], Asset.EQU = [Sheet1_OLD]![EQU], Asset.BTED = [Sheet1_OLD]![BTED], Asset.Tel_recording = [Sheet1_OLD]![V_Recording], Asset.Tel_Build = [Sheet1_OLD]![Phone Built], Asset.ACD = [Sheet1_OLD]![ACD];


”Beginning is half done.”

 

[Remou]

Try updating one table at a time. Limit the joins to those necessary for each update.

http://lessthandot.com

 

[Alpha008]

No luck yet !

”Beginning is half done.”