Arthur Fuller
artful at rogers.com
Tue May 9 21:01:25 CDT 2006
What a bummer. Now that I am on this project where the whole focus is SQL, I have taken enormous pleasure in puncturing opinions of Access. In a very few minutes, I knocked together an app that would talk to the system tables, with combo-boxes and listboxes etc. Heads turned and eyes rolled. These SQL guys simply had no idea that Access could do that. I would hate to see ADP go the way of the dodo. Arthur Martin Reid <mwp.reid at qub.ac.uk> wrote: Marty This MAY be incorrect and is written as of tonight so could change totally between now and release. They will not handle the new data types but should function as before with SQL 2005 peovided you have only those DTs supported by SQL Server 2000. At the moment there is no way to work with 2005 via ADPs. There are some issues still that appear to be outstanding. In fact I have posted to them about several including the fact that no server object appear when using 2005 but they are picked up by the wizards but dont show in teh Access container. Asd of about 5mins ago I have had no luck at all with ADPs and SQLS erver 2005 other than linking to the tables in Access as before. They are REALLY pushing linking tables as first choice over ADPS. ADPs will not receive the same focus in future development as linking to MDBs etc will I did get that much out of them 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: Sun 07/05/2006 17:55 To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access 2007 - QUick Survery One question I am seeing is what are the exact restrictions on running either Access 2003 or 2007 ADP's versus SQL 2005. Will they handle new complex data types? What modifications will be needed. Can you use Access 2007 ADP's for any future development. Can you run an ADP developed under 2003 and run it in 2007 against SQL 2005 by just changing the connection string, assuming you have done an SQL 2000 to 2005 conversion? Martin Reid wrote: >Quick Survey > >Access 2007. What sort of information as professionals would you like to see about Access 2007? > >Martin > > > >Martin WP Reid >Training and Assessment Unit >Riddle Hall >Belfast > >tel: 02890 974477 > > > > > > -- Marty Connelly Victoria, B.C. Canada -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com