Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Can Access FrontEnds run T-SQL/XML Expand / Collapse
Author
Message
Posted Monday, September 10, 2012 2:45 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 14, 2014 4:39 AM
Points: 100, Visits: 790
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
Posted Monday, September 10, 2012 6:42 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 8:52 AM
Points: 142, Visits: 518
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.

Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
Post #1356697
Posted Wednesday, September 19, 2012 12:43 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 14, 2014 4:39 AM
Points: 100, Visits: 790
Thanks, so with Access can you manipulate namespaces like you see doing here> http://www.sqlservercentral.com/Forums/Topic1360396-21-1.aspx
?
Post #1361152
Posted Saturday, September 29, 2012 7:21 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 8:52 AM
Points: 142, Visits: 518
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.

Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
Post #1366186
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse