[AccessD] Access 2007 Upsizing Wizard Missing

Thanks, Darryl!  I had never noticed that.

Doug


On Mon, Feb 17, 2014 at 3:52 PM, Darryl Collins <
darryl at whittleconsulting.com.au> wrote:

> Might be a bit OT here, but in A2010 the SQL Server migration tool is on
> the ribbon in the Access app and works well.  Indeed I only used it the
> other day to move the a few hundred tables from an Access database to SQL
> Server 2012 (Express).
>
> It is on the Ribbon under "Database Tools".  it straightforward to do.
>
> Regards
> Darryl.
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:
> accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
> Sent: Tuesday, 18 February 2014 9:45 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Access 2007 Upsizing Wizard Missing
>
> Jim,
>
> As suggested, I installed SSMA and tried to run it. Step 1, Choose an
> Access database, worked fine. Step 2, Connect to SQL Server, failed. The
> message suggests that I ensure that SQL Server is configured to allow
> remote connections (provider: Named Pipes provider, error 40 - Could not
> open a connection to SQL Server)
>
> I have SSMS open at the moment. The server name is (localhost) and it
> works fine. I'm using the same server name in SSMA but getting the error
> above.
>
> I've forgotten how to check that remote connections are allowed. Can you
> (or someone else) remind me?
>
> Thanks,
> Arthur
>
>
> On Mon, Feb 17, 2014 at 1:45 PM, Arthur Fuller <fuller.artful at gmail.com
> >wrote:
>
> > Thanks, Jim. I also recall a 3rd Party implementation from SSW
> > Software in Australia. Maybe I'll have a look there as well as Googling
> SSMA.
> >
> > Arthur
> >
> --
> 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
>