[AccessD] Access 2000/ 2002 ADP with SQL SERVER 2005?

I use Enterprise Manager to do all the BE stuff.

On 13 Oct 2006 at 12:35, David McAfee wrote:

> Do you guys develop new BE stuff (Sprocs, views, tables) from the front end?
> I tend to do everything in the back end and just work on front end stuff in
> the front end.
> 
> David
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of MartyConnelly
> Sent: Thursday, October 12, 2006 8:01 PM To: Access Developers discussion
> and problem solving Subject: Re: [AccessD] Access 2000/ 2002 ADP with SQL
> SERVER 2005?
> 
> 
> You will have problems.
> You will not be able to use any of the designers with SQLS 2005
> databases, whether it's SQL Express or the Developer edition. IOW,
> you won't be able to create databases, tables, views or any other
> database objects from an ADP.  Installing SQL Express in crippled
> SQL 2000 compatibilty mode will allow this however.
> Essentially you will have to develop an ADP against SQL 2000
> and then upgrade to SQL Express.
> 
> Also SQL-DMO has changed to SQL-SMO.
> 
> 
> Sad Der wrote:
> 
> >Hi group,
> >
> >we've just started a new project. We want to create an ADP. We've never
> done this using a SQL Server 2005 back-end. Are there any known
> issues/problems why we shouldn't do this?
> >
> >Regards,
> >
> >Sander
> >
> >
> >
> >
> >
> >
> 
> --
> Marty Connelly
> Victoria, B.C.
> Canada
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

-- 
Stuart