Doug Murphy
dw-murphy at cox.net
Sun Mar 13 16:46:44 CDT 2011
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