[AccessD] From your friendly moderator

Hi Marty:

Just checked it out and it is brilliant. That article is an incredible
merging of MS Access, SQL 2005/2008, API/DLL to COM, VB-C#.Net, XML to
WebServices and much of the new Access features seem to have AJAX
functionality as well. I wonder which list that will fit into?

Seems that MS is expanding into ESRI territory... this should be
interesting. Oracle has long been the darling but now MS is going on step
further into becoming a direct competitor.  

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly
Sent: Tuesday, May 15, 2007 5:48 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] From your friendly moderator

Some of that is already here with Managed Add-ins for Access 2007 and MS 
Visual Studio 2005
I use VB.Net but any other language could be used like Cobol.Net.  You 
can also do this directly
with a VB.Net dll & tlb with a COM Class template too.
One of these days, I'll try to get a SQL query using XLINQ to return XML 
rather than a
recordset to Access but that requires Net Framework 3.0 or 3.5 and SQL 2005

Here is Ken Getz's article on it.
http://msdn2.microsoft.com/en-us/library/aa902693.aspx

Where it might get wilder.

This week Microsoft's announced that the next release of SQL Server,
SQL Server 2008, expected next year, will include support for spatial data.
Probably done with an R* indexed data engine. This means you can handle
GIS geocoded data from Access as a frontend. You can do this now with ESRI
SQL Server 2008 is called Katmai, see Shamil now they are using volcanoes.