Martin Reid
mwp.reid at qub.ac.uk
Fri Oct 13 10:37:39 CDT 2006
ADPs will function with SQL Server 2005. At least in Access 2007 they do. Maritn Martin WP Reid Training and Assessment Unit Riddle Hall Belfast tel: 02890 974477 ________________________________ From: accessd-bounces at databaseadvisors.com on behalf of Dan Waters Sent: Fri 13/10/2006 16:31 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access 2000/ 2002 ADP with SQL SERVER 2005? 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 <http://www.databaseadvisors.com/> -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com/>