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

__________________
slypunk

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

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

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.