<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Microsoft Access
»
Microsoft Access
»
Can Access FrontEnds run T-SQL/XML
Can Access FrontEnds run T-SQL/XML
Rate Topic
Display Mode
Topic Options
Author
Message
grovelli-262555
grovelli-262555
Posted Monday, September 10, 2012 2:45 AM
SSC Journeyman
Group: General Forum Members
Last Login: Today @ 1:22 PM
Points: 81,
Visits: 680
Hi guys, I'm not knowledgeable about XML or T-SQL but do you know whether it's possible to use syntax such as Arthur's revised query in Access?
I know that Access can run stored procedures in SQL Server but can the above be considered a stored procedure?
http://www.sqlservercentral.com/Forums/Topic1355591-21-1.aspx
Post #1356594
WendellB
WendellB
Posted Monday, September 10, 2012 6:42 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, May 16, 2013 6:46 AM
Points: 106,
Visits: 405
I don't see why you couldn't use a pass-through query to invoke the SQL Server function - although there are several limitations with pass-through queries. But Access has had the ability to read and import XML files (that are well structured) since 2003, and can display it in a tabular format, so I would probably do it that way.
Post #1356697
grovelli-262555
grovelli-262555
Posted Wednesday, September 19, 2012 12:43 AM
SSC Journeyman
Group: General Forum Members
Last Login: Today @ 1:22 PM
Points: 81,
Visits: 680
Thanks, so with Access can you manipulate namespaces like you see doing here> http://www.sqlservercentral.com/Forums/Topic1360396-21-1.aspx
?
Post #1361152
WendellB
WendellB
Posted Saturday, September 29, 2012 7:21 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, May 16, 2013 6:46 AM
Points: 106,
Visits: 405
I'm in way over my head on this, as I've never done any .NET programming or worked extensively with xml, but in theory I don't see any reason why it wouldn't work. But it's not clear to me what value there would be in using an Access front-end to do that sort of thing when there are other tools with fewer limitations. It seems a bit like trying to pound a nail in using a screwdriver.
Post #1366186
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
