MartyConnelly
martyconnelly at shaw.ca
Thu Aug 24 11:50:56 CDT 2006
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