[AccessD] A2K3 ADP

I haven't checked the CRTM, CTP  or whatever they are calling the latest 
release of SQL Express 2005
but 2003 ADP's will only connect normally  if SQL Express is installed 
in SQL 2000 degraded compatibility mode.
Otherwise there are restrictions on table creation etc. from the ADP.
At least the previous Beta didn't

http://blogs.msdn.com/sqlexpress/archive/2005/09/15/467774.aspx

FAQ: How to connect to SQL Express from "downlevel clients"(Access 2003, 
VS 2003, VB 6, etc
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

John Bartow wrote:

>Does anyone have comments on ADPs with A2K3?
> 
>IIRC there were some negatives brought up about them here with previous
>versions.
> 
>Are you using ADPs for SQLServer data sources or MDBs via DB connectivity?
> 
>TIA
>John B.
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada