MartyConnelly
martyconnelly at shaw.ca
Fri Oct 13 13:25:36 CDT 2006
I tried Access 2007 ADP Beta 1 against SQL Express months ago and it was a bit odd maybe there are fixes in Beta 2. You get error messages like MS Access is an earlier version prior to SQL server 2005 and it will not save the queries, if you use prior versions of Access ADP like 2003 against SQL 2005 See if using ADP version's prior to Access 2007 https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=732010&SiteID=1 I believe some SQL 2005 datatypes are only accessible from .accdb files like Complex data (multi-valued data types) The ADP architecture was designed to create client-server applications. Because of this, there is a limit to the number of records that Access returns in any recordset. This limit is configurable, but you may need to build a lot of filtering into your application to avoid hitting the limit. Martin Reid wrote: >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