[AccessD] Access Data Project

Actually thats not really correct as far as I know. As long as you dont use any of the new SQL 2005 data types they function as before. The new Access data types do actually convert but lose the functionality they have in the new databse file type.
 
 
 
Martin
 
Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast
 
tel: 02890 974477
 

________________________________

From: accessd-bounces at databaseadvisors.com on behalf of MartyConnelly
Sent: Thu 24/08/2006 17:50
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access Data Project



ADPs do not and will not support SQL Server 2005 or SQL Express (new
form of MSDE)
except in a very basic way or by installing in crippled SQL 2000
compatibilty mode.
 In other words, you won't be able to create databases, tables, views or
any other
database objects from an ADP against newer versions of SQL.  Should be
able to read and
write older ADP's vs SQL 2005 but I don't know what happens with newer
SQL complex
and xml datatypes.

More here
http://blogs.msdn.com/access/

Tesiny, Ed wrote:

>I'm not sure if it was on this list but I remember some discussion that
>ADPs were going away in the next version of Access.  Anyone remember
>something about this?
>TIA
>Ed
>
>Edward P. Tesiny
>Assistant Director for Evaluation
>Bureau of Evaluation and Practice Improvement
>New York State OASAS
>1450 Western Ave.
>Albany, New York  12203-3526
>Phone:  (518) 485-7189
>Fax:  (518) 485-5769
>Email: EdTesiny at oasas.state.ny.us
>
> 
>

--
Marty Connelly
Victoria, B.C.
Canada

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com/>