If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
I think your latest idea is probably the SQL code way of doing what I did in
the UI, ie setting the "unique record" property to 'yes', as the SQL behind the UI is as follows. DELETE DISTINCTROW tblLOCAL_WORKS_ORDER.* FROM WORKS_ORDERS_TO_DELETE LEFT JOIN tblLOCAL_WORKS_ORDER ON WORKS_ORDERS_TO_DELETE.WORKS_ORDER = tblLOCAL_WORKS_ORDER.WORKS_ORDER; Regards Tom "Andrea Montanari" wrote in message ... found another way... modifying the SQL statement to DELETE DISTINCTROW SQLtable.* FROM SQLtable a JOIN AccessTable b ON a.ID = b.ID did the trick, even with no primary key -- Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0 (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual interface) --------- remove DMO to reply |
#12
|
|||
|
|||
I think your latest idea is probably the SQL code way of doing what I did in
the UI, ie setting the "unique record" property to 'yes', as the SQL behind the UI is as follows. DELETE DISTINCTROW tblLOCAL_WORKS_ORDER.* FROM WORKS_ORDERS_TO_DELETE LEFT JOIN tblLOCAL_WORKS_ORDER ON WORKS_ORDERS_TO_DELETE.WORKS_ORDER = tblLOCAL_WORKS_ORDER.WORKS_ORDER; Regards Tom "Andrea Montanari" wrote in message ... found another way... modifying the SQL statement to DELETE DISTINCTROW SQLtable.* FROM SQLtable a JOIN AccessTable b ON a.ID = b.ID did the trick, even with no primary key -- Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0 (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual interface) --------- remove DMO to reply |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Book recommendations, please | Top Spin | New Users | 2 | March 1st, 2005 12:43 AM |
Encrypt AccesS File? | milest | General Discussion | 2 | February 9th, 2005 07:58 PM |
Images in a database | Franz | General Discussion | 10 | October 7th, 2004 09:35 AM |
Access XP Compared to Access 2003 | Mardene Leahu | New Users | 1 | October 1st, 2004 05:11 AM |
Access Front End with MSDE SQL Server Instance Back end | Andy | General Discussion | 3 | August 31st, 2004 03:58 PM |