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

Dan Waters dwaters at usinternet.com
Fri Oct 13 10:31:05 CDT 2006


Hi Sander,

You will be able to create an Access MDB with SQL Server 2005 Express.  SQL
Server Management Studio Express is a GUI for SQL Server 2005 Express.  It
has everything you need to manage the database objects.

Dan Waters

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly
Sent: Thursday, October 12, 2006 10: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




More information about the AccessD mailing list