[AccessD] Running Access XP ade With Access 10 and SQL2008 upgrade

Thanks Bill,

That looks very promising.  Much appreciated.

Regards

David

At 4/02/2011, Bill Patten wrote:
>?David,
>I don't know if this will help as I do not have Access XP any more, I do
>however have an adp Access2003 and did the  following tests.
>Created and ADE
>restored a Sql  Server 2000 backup into a 2008 Sql Server
>Opened a Win7 32 bit VM with Office 2010 installed in it
>Opened the 2003 ADE with 2010 and used my built in change SQL Server routine
>to connect to the 2008 Server. My program then prompted me for the database
>update to the latest version.
>I pointed my update routine to the correct .Sql file and it updated the
>server correctly, this is good that means some things are working OK.
>I opened a few forms and made a few entries and everything seemed to work
>with one exception.
>My automatic throw away the ribbon and use the old Office menus did not
>work. I suspect this is because it is an ADE and can't make the changes to
>the program. Selecting Add-ins does show the Office Menus but on top of the
>ribbon.
>
>I don't use ADE's any more, but lock down the ADP as much as possible to
>keep users out. If they get in and screw it up then they can pay me to fix
>it.
>
>
>The good news is 2010 did open a 2003 ade and didn't complain, obviously
>more testing is needed but at least on the surface it appears to work.
>
>By the way, there are some free Office 2010 downloads available, I think
>good for 30 days or so and if you have any Virtual machines or spare tests
>machines you can easily do some testing without screwing up you development
>system.
>
>HTH
>
>Bill
>
>--------------------------------------------------
>From: "David Emerson" <newsgrps at dalyn.co.nz>
>Sent: Thursday, February 03, 2011 3:39 PM
>To: "Access Developers discussion and problem solving"
><accessd at databaseadvisors.com>; <dba-SQLServer at databaseadvisors.com>
>Subject: [AccessD] Running Access XP ade With Access 10 and SQL2008 upgrade
>
>I have a client who is looking at upgrading their SQL2005 to SQL2008.
>
>Currently we are running an Access XP ade connected to SQL2005.
>
>Does anyone have any experience or know if an Access XP ade will
>connect to an SQL2008 database
>
>Will an Access XP ade run in Access 2010?
>
>Can Access 2010 be used to create an ade?
>
>Are there any issues I should be aware of in upgrading an SQL2005
>database to SQL2008?
>
>
>Regards
>
>David Emerson
>Dalyn Software Ltd
>Wellington, New Zealand
>
>--
>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