[AccessD] From your friendly moderator

MartyConnelly martyconnelly at shaw.ca
Tue May 15 19:48:28 CDT 2007


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.


Jim Lawrence wrote:

>I agree that the borders between the various lists have been criss-crossed
>as many have been using the shot-gun approach to ask and answer questions.
>
>On the other hand much of the newer technology is morphing and the strict
>borders are no longer realistic. Example the Access list looks more like the
>'Access.Net using SQL 2005' list. No longer does Access just use the MDB
>database and eventually SQL DB with .Net/Framework/Mono calls will become
>fully incorporated.
>
>Jim    
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Francisco Tapia
>Sent: Tuesday, May 15, 2007 9:48 AM
>To: Access Developers discussion and problem solving
>Subject: Re: [AccessD] From your friendly moderator
>
>Well said!
>
>
>On 5/14/07, Andy Lacey <andy at minstersystems.co.uk> wrote:
>  
>
>>We seem to have let our standards slip recently regarding posting topics
>>to
>>the appropriate lists, and regarding cross-posting. Can I just remind
>>everyone that we have a specific SQL-Server list, one for VB, one for
>>Visio,
>>a dba-Tech list for other IT matters, and an OT list for non-IT matters
>>(see
>>http://www.databaseadvisors.com/lists/whatandhow.asp )? Please make more
>>use
>>of these other lists and try to limit AccessD to Access stuff. I know that
>>AccessD is the main list, but SQLServer and VB particularly have many
>>members and are specifically geared to answering questions on those
>>topics.
>>If you have a question which belongs on one of the other lists I urge you
>>to
>>please post it on the appropriate list first. If you don't get the
>>response
>>you're after and believe that reposting to AccessD will help then of
>>course
>>you're going to, but you should then append "(originally posted to
>>dba-xx)"
>>to your subject. This will help people who have already seen the original.
>>It may even encourage wider membership of the other lists. Please avoid
>>the
>>scatter-gun approach of just posting the same question straight away to
>>all
>>of the lists. This generates wasted bandwidth, is a particular irritant
>>for
>>those on multiple lists and uses up storage in our archive. Many thanks
>>for
>>your co-operation.
>>
>>-- Andy Lacey
>>http://www.minstersystems.co.uk
>>    
>>

-- 
Marty Connelly
Victoria, B.C.
Canada




More information about the AccessD mailing list