[AccessD] Access 2007 Upsizing Wizard Missing

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