Martin Reid
mwp.reid at qub.ac.uk
Fri Oct 13 14:01:26 CDT 2006
In A2007 they work fine. The complex types are a sharepoint feature and not available in any version of SQL Server AFAIK, You get a Csv string when you upsize. I actually wasnt aware of this Marty re earlier versions. I have been using 2007 without exception for a long time now with SQL Server 2005 and havnt touched it with an early version in some time. Best Wishes Martin Martin WP Reid Training and Assessment Unit Riddle Hall Belfast tel: 02890 974477 ________________________________ From: accessd-bounces at databaseadvisors.com on behalf of MartyConnelly Sent: Fri 13/10/2006 19:25 To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access 2000/ 2002 ADP with SQL SERVER 2005? 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com/>