p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Server 2000 (http://p2p.wrox.com/forumdisplay.php?f=20)
-   -   RE: Upsizing wizard (http://p2p.wrox.com/showthread.php?t=240)

sherr8 June 6th, 2003 10:26 AM

RE: Upsizing wizard
 
Hello,

I am trying to test one of the DB at work by upsizing it to SQL. I have a problem with upsizing the wizard in Access. I receive the message Overflow and I went to google.com and it said to download Access 2000 and SQL Server 2000 Readiness Update and when I do it gives me an error that says it is not in SR-1 level. I then kept searching for other solutions and another website explained that before installing Access 2000 and SQL Server 2000 Readiness Update to install Microsoft Office 2000 SR-1 and when I do it is saying that my network resource is unavailable. Any suggestions? Your help is greatly appreciated.

Thank you

slypunk

jesseleon June 10th, 2003 12:50 PM

All the upsizing wizard does really is upload the tables in your access db. If your having trouble with the wizard then just try it the other way around; create a new db in your server, then just import your access tables either through an import wizard or a DTS.

Thanks,
Jesse

Graham June 12th, 2003 12:19 PM

Hi

I've recently been moving Access MDBs into SQL 2k and hit the same error.

Turned out that SQL DTS was creating Access Date/Times as SmallDateTimes. In the end the only way I could fix this was to manually amend the tables in DTS then wrote a simple script to change all small dates to date times.

Regards
Graham

hortoristic June 12th, 2003 12:49 PM

Inside of DTS you could have TRANSFORMED just that one column and it would have corrected it for you on the fly. Have had to use that solution many times.


All times are GMT -4. The time now is 12:32 AM.

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