JWColby
jwcolby at colbyconsulting.com
Tue Mar 27 10:51:55 CDT 2007
Thanks for this. I have downloaded it and am testing it now. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Tuesday, March 27, 2007 9:14 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access upgrade to sql server express John, By the way, MS has a new upsizing wizard called SQL Server Migration Assistant (SSMA) for Access. They have other flavors of SSMA - for Oracle, etc. This has been available for a few months - it you're using this it would be good to know how it works out! One possible drawback is that MS suggests that the minimum RAM to run SSMA is 1 Gb! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby Sent: Tuesday, March 27, 2007 7:19 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access upgrade to sql server express I have it turned on. It was installed in the on state (automatic as well) although the browser wasn't. I turned the browser on as well. Basically Access itself does not see it in the list of available SQL Servers although it sees a handful of other servers. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Tuesday, March 27, 2007 7:35 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access upgrade to sql server express John, >From what I remember, SQL Express is installed in an 'off' condition. >It can be turned 'on' by going into services. Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby Sent: Monday, March 26, 2007 10:48 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Access upgrade to sql server express Can Access do an upgrade to SQL Server Express? When I try and run the upsizing wizard it does not display the local SQL Server Express instance running on the same machine. John W. Colby Colby Consulting www.ColbyConsulting.com -- 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 -- 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