August 29, 2008 03:49pm pdt

1. vadimrapp1 77,150
2. LSMCons... 29,643
3. boag2000 20,125
4. rorya 11,400
5. peter57r 10,550
6. chapmandew 9,748
7. jimhorn 9,618
8. angelIII 9,325
9. DatabaseMX 8,800
10. kelvinsparks 7,750
11. jimpen 7,625
12. TextReport 7,400
13. SidFishes 7,200
14. capricorn1 6,600
15. zorvek 6,000
16. LPurvis 5,964
17. matthews... 5,400
18. adraughn 4,750
19. ee_rlee 4,500
20. ScottPletc... 4,080
21. omgang 4,000
21. dqmq 4,000
21. webtubbs 4,000
24. MikeToole 3,550
25. jlaborde 3,500

1. LPurvis 89,936
2. LSMCons... 80,400
3. peter57r 79,386
4. vadimrapp1 77,150
5. rockiroads 44,447
6. capricorn1 39,518
7. SidFishes 37,544
8. jimhorn 36,229
9. stevbe 31,815
10. nico5038 26,250
11. thenelson 24,639
12. JDettman 20,668
13. boag2000 20,265
14. jefftwilley 19,800
15. angelIII 18,577
16. harfang 17,972
17. Arthur_... 16,774
18. kelvinsparks 16,125
19. TextReport 15,950
19. DatabaseMX 15,950
21. jimpen 14,125
22. jadedata 12,677
23. shanesue... 12,514
24. matthews... 12,125
25. puppydog... 11,538

05.29.2007 at 10:30AM PDT, ID: 22600169

	[x] Attachment Details

Update SQL Server table via ADP form.

Asked by tomllewis in Microsoft ADP

Tags: update, sql, adp, table, access

I am creating an Access Project (Access 2003) connected to a SQL Server 2005 database. I need to present the results of a query (Stored procedure? -- ADO? -- View?) to the user on a form and allow him/her to make changes. I will have concurrent users. What is the best way to do this? Do you have a code example? The query is an inner join between two tables. Changes are only made to one table. This was so easy in Access.Start Free Trial

Keywords: Update SQL Server table via ADP form.

	Title
1	inner join with multiple tables
2	How do you do an inner join to fill a dat…
3	INNER JOIN question
4	PHP Inner Join thing...
5	T-SQL Update Inner Join Syntax
6	ADP calculated column and form footer…

Loading Advertisement...

20080716-EE-VQP-32

Update SQL Server table via ADP form.

Asked by tomllewis in Microsoft ADP

Tags: update, sql, adp, table, access

About this solution