Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 19th, 2004, 10:04 PM
Registered User
 
Join Date: Jan 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Upsizing Wizard in Access 2003

I can not get the Upsizing Wizard to work.
XPPro
SQLServer 2k Developer
Access 2003
Norton Firewall

I can get the Wizard to run on my laptop, same OS and SQL. Access 2002, no firewall.

But on the Desktop Machine no matter what I do, when I run the Upsizing Wizard it always tells me the it can't find the server or access denied. I've tried both kinds of authentication to no avail.
I can go into EM and work with the DBs. I can link them to Access via ODBC and it works.

I have tried turning off the Firewall but that doesn't help either.

Any suggestions would be appreciated.

Thanks

 
Old January 20th, 2004, 06:38 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Run the wizrd from the laptop. The tables are the only item you want to upsize anyway. The queries do not get upsized well at all.



Sal





Similar Threads
Thread Thread Starter Forum Replies Last Post
Arabic problem when use upsizing wizard naeem.net SQL Server 2005 1 June 3rd, 2008 02:33 PM
Upsizing Issues, Access to SQL Server gvcooper SQL Server 2005 2 May 11th, 2006 07:49 PM
Access 2003 Wizard Problems Steve2909 Access 7 April 12th, 2006 07:14 AM
RE: Upsizing wizard sherr8 SQL Server 2000 3 June 12th, 2003 12:49 PM
RE: Upsizing wizard sherr8 Access 3 June 9th, 2003 11:34 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.