Posted by Wes Groleau on 02/05/07 05:05

Jonathan Roberts wrote:
> Wes Groleau wrote:
>> The upsize Wizard does not work. On the third or fourth
>> page, it pops up a box saying nothing but "Overflow"
>> Nothing happens in SQL Server.
>
> Glad you mentioned it. You have hit the number one common problem with
> the wizard. It does work but you have to overcome this issue. Google
> it to find many pages of info. One KB is here:
> http://support.microsoft.com/kb/272384. I don't remember the exact fix,
> but it wasn't hard to resolve.

"Obtain the latest service pack" You're right--that's not hard.
I didn't bother to look because my predecessor said that the only
fix was to install Access 2003. Installing a new version--or installing
a service pack--is not something our I.S. department will do on demand.

> If you don't want to go that route, you can certainly pull out all your
> queries manually and create views in SQL Server. I don't know of an
> automated way to do this. If you have a lot of queries, this way may
> not be practical.

It's not all that bad. Shift to SQL view. select, copy, "New View",
paste, save. But still, automation would be nice.


--
Wes Groleau
http://freepages.rootsweb.com/~wgroleau/Wes

[Back to original message]