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

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