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