[AccessD] Upsizing Access 2010 database to SQL Server 2008 R2 Experiment

Doug Murphy dw-murphy at cox.net
Mon Mar 14 18:30:17 CDT 2011


All,

I am wondering if this is an Access 2010 to SQL Server 2008 thing. I have a
test computer set up with Windows XP, Access 2010 and SQL Server Express
2005. The upsizing wizard works as advertised. When I try to upsize the test
backend on my development computer Win 7/64, Access/32, and SQL Server 2008
R2 I get an message stating that
"C:\Users\'\AppData\Roaming\Microsoft\Access\ACWZUSR12.ACCDU" isn't found or
spelled correctly, but it is there, and the table list is empty in the
wizard. I reinstalled the named file and it still I still get the message.
The named file is the Access Wizard Add-in. It will open.  I also tried this
on a laptop with Win 7/32 with office 2010 and SQL Server Express 2005 and
that worked. Seems to be something with SQL Server 2008 or the 64 bit
version of Windows.

Any thoughts? Has anyone tried the upsizing wizard in Access 2010 with SQL
Server 2008? Not much in Google help for this one.

Doug

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy
Sent: Sunday, March 13, 2011 2:47 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Upsizing Access 2010 database to SQL Server 2008 R2
Experiment

Hi Dan,

Thanks for the thoughts. This is the back end so working with the actual
tables. I am apparently getting a good connection as the wizard isn't
complaining, it just isn't showing the access tables which you would think
would be the first thing it would do since it is part of Access.

I have done this a couple of times from Access 2007 and it worked with SQL
server 2005 pretty easily. 

Doug

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Sunday, March 13, 2011 2:42 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Upsizing Access 2010 database to SQL Server 2008 R2
Experiment

Hi Dave,

I would guess that if any of your tables are actually links, then nothing
would show for them.

Another issue I came across yesterday is that to complete the export, you
must have TCP/IP enabled in the SQL Server Configuration Manager.
Apparently the upsizing wizard does not use Named Pipes or Shared Memory.

Good luck!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy
Sent: Sunday, March 13, 2011 4:34 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Upsizing Access 2010 database to SQL Server 2008 R2
Experiment

Folks,

I just started experimenting with Access 2010 and SQL Server 2008 R2
Express. One experiment was to see how the upsizing wizard works, or in this
case doesn't work. I got a copy of Northwind for Access 2010. Split the
database. Then in the back end I fired  up the upsizing wizard. Everything
goes well until we get to the part where you select the tables to export
from a list box. Even though the back end is only tables the list box in the
wizard is empty. Any idea what is going on here?

Thanks in advance.

Doug

--
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




More information about the AccessD mailing list