Martin Reid
mwp.reid at qub.ac.uk
Fri Oct 13 14:42:52 CDT 2006
depends. I would do both. I usually would have an ADP to get at the graphical tools even if working in a linked app. Though with SQL Server 2005 this is really required anymore but I use it as a teaching tool as well. Maritn Martin WP Reid Training and Assessment Unit Riddle Hall Belfast tel: 02890 974477 ________________________________ From: accessd-bounces at databaseadvisors.com on behalf of David McAfee Sent: Fri 13/10/2006 20:35 To: Access Developers discussion and problem solving Subject: Re: [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 <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/>