help with upsizing wizard

[elaine]

I having problems running the upsizing wizard in access
xp. Problem is my system seems to halt process where as
it will start going through the forms then task manager
says its not responding. I'm trying to convert to .adp. I
never get a report log either. does anyone have any ideas
what I should try?
Any information will be greatly appreciated thanks, Elaine

 

[Marshall Smith]

When you say "halt," how long are you talking? Because it can take a long
time to process. And, while it is working, it will return "Not Responding"
to the Task Manager. That's not because it's hung up, but because it's too
busy to respond politely when asked what it's up to.

It could also be getting hung up on some of the changes in data type. For
instance, the bit datatype in SQL Server is triple-state (yes, no, null),
while the yes/no datatype in Access is dual-state (it won't recognize null).
This can cause some weird behaviors on forms and whatnot. Depending on
exactly what you have, the wizard could be getting confused (one of the
eternal problems with wizards in general).

An option you might try is to split the database into a front end and back
end (there is a Database Splitter wizard to help with this, too). Then,
upsize each separately.