March 30, 2006 at 1:41 pm
In 2000 EM I was able to right click on a table and bring up an editable, filtered resultset. Now in 2005 all I can find is Open Table. I did that and then used the SQL pane to bring back only the few records I wanted.
However, since it involved a join the cells in the results pane are now read only. I want to edit them in this pane instead of writing an update query. The tool shows the records as "Cell is REad only." It was very easy and obvious in 2000. Am I missing something with 2005?
March 31, 2006 at 8:53 am
I too have ran into the same situation. The only workaround I've cam up with so far is to move my 'join' into the 'where' clause. For example.
SELECT * FROM TableB WHERE TableB.TableA_ID IN ( SELECT TableA_ID FROM TableA )
Mike
April 4, 2006 at 12:14 pm
Mike, you're right - that worked for me too. Thanks for the the workaround. We shouldn't have to do this tho! 🙁
May 8, 2006 at 8:13 am
I've the same problem. But your workaround doesn't solve my whole problem.
I want to edit table 'Pers' and sort it by 'Pers_Ex.SortOrder'
Here is the example:
SELECT Pers.Name
FROM Pers INNER JOIN Pers_Ex
ON Pers.ID = Pers_Ex.ID
ORDER BY Pers_Ex.SortOrder
With the workaround (WHERE IN) the sorting is not possible 🙁
I want to use such views in Access-Forms.
Do you have any further ideas ?
May 8, 2006 at 8:42 am
Roman,
Give this a try, it seemed to work for me.
SELECT
Pers.Name
FROM
Pers
ORDER
BY
(
SELECT Pers_Ex.Pers_Ex_SortOrder FROM Pers_Ex WHERE Pers_Ex.ID = Pers.ID )
If the target for the query is an Access form why not develop the query there?
Mike
May 9, 2006 at 6:22 am
Hi Mike,
Great, that works fine for me!
Unfortualy I've to rewirte a lot of queries because of that limitation :-/
Con. Access: I've a Access FrontEnd/BackEnd application where I upsize the BackEnd to SQL Server. At the FrontEnd I decide to use only ADO connections - maybe a great fault ?
Roman
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply