[AccessD] The future of Access, .NET and SQL

Well Sharepoint or WSS sits on top of  SQL Server, you can send Access 
2003 tables to WSS "lists"
directly via a bit of vba code and edit them via the web. If you see 
Sharepoint Lists, think Access tables.
I still don't know how you do referential integrity or multi list 
queries in WSS. On my todo lists.
The code is fairly simple to swap Access tables to WSS back and forth.
I think you can do this with lower forms of Access too.

The following example exports the contents of the Customers table to a 
new list
named Customer List on the "http://example/WSSSite" Windows SharePoint 
Services site.


DoCmd.TransferDatabase transfertype:=acExport, databasetype:="WSS", _
                       databasename:="http://example/WSSSite", _
                       objecttype:=acTable, Source:="Customers", _
                       Destination:="Customer List", structureonly:=False

Martin Reid wrote:

>All I can pass on is what I hear and pick up from the web. Personally I 
>think they will make a hugh push towards SharePoint technologies with the 
>new release of Office and that seems to be the direction they are heading in 
>talks we have been having with them re projects in the University. On the 
>Access front I think MS focus is on .NET and XML as data the data stores but 
>thats my own opinion. RE JET I did hear sometime ago that it would no londer 
>be developed but as John says I am sure it wil remain about. I did also hear 
>the new engine woudl work with JET.
>
>I do know that when the Access dev team reps where in the UK they didnt want 
>to meet developers but wanted to meet with users. Now that I do know and 
>have an email about somewhere that says that. Maybe that sort of sums up 
>what they think.
>
>
>Martin
>
>
>
>
>----- Original Message ----- 
>From: "Susan Harkins" <ssharkins at bellsouth.net>
>To: "'Access Developers discussion and problem solving'" 
><accessd at databaseadvisors.com>
>Sent: Tuesday, September 27, 2005 7:38 PM
>Subject: Re: [AccessD] The future of Access, .NET and SQL
>
>
>  
>
>>Wouldn't know how -- I have been told that it's a huge break from what 
>>we've
>>known up till now. I don't know how much they will maintain Jet for 
>>backward
>>compatibility. I am probably dead to Access except for old stuff -- I 
>>don't
>>want to keep this up -- I'm tired of being constantly forced into new
>>technologies when what I've got works just fine.
>>
>>Susan H.
>>
>>Hi Susan
>>
>>Couldn't you enlightened people be a bit more informative please?
>>
>>-- 
>>AccessD mailing list
>>AccessD at databaseadvisors.com
>>http://databaseadvisors.com/mailman/listinfo/accessd
>>Website: http://www.databaseadvisors.com
>>
>>    
>>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada