Access 2000 upsizing trouble

I am upgrading an Access 2000 database to SQL Server 7.0 and 2000. When I
run the upsizing wizard it works great, but when I view the tables within
SQL only the first two tables appear to have data. I deleted the SQL
database and tried again. I tried upsizing one table (has 3500 records) and
it worked.
I have many tables of varying record size but the entire database is around
6MB. I don't find any information about why it works when I do one table at
a time and doesn't work when I try to upsize all the tables. Any help is
greatly appreciated.
WB"WB" <none> wrote:
>I am upgrading an Access 2000 database to SQL Server 7.0 and 2000. When I
>run the upsizing wizard it works great, but when I view the tables within
>SQL only the first two tables appear to have data. I deleted the SQL
>database and tried again. I tried upsizing one table (has 3500 records) and
>it worked.
Dates outside the range which SQL Servers default date formats can
cause problems. For more details and other items see the Random
Thoughts on SQL Server Upsizing from Microsoft Access Tips page at my
website.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm|||Hi WB,
This problem is wired. I would like you to provide more information so that
I can narrow down it?
1. Do you mean that there is not any error message?
2. Does this problem occur on SQL Server 7.0 or SQL Server 2000? What is
the Service Pack of the SQL Server?
3. I would like you to try to upsize all the tables of the Access 2000
database to SQL Server separately. Does the same problem occur again?
4. Please try to transform data from Access to SQL Server using DTS. For
additional information regarding DTS, please refer to the following article
on SQL Server Books Online:
Topic:" DTS Basics".
Thanks for using MSDN newsgroup.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.|||Hi Michael,
During this upsize I did have some errors. The problem (errors) weren't
specifically with the tables that didn't upsize the data.
I have experienced this with both versions.
Yes, after I posted the message I went back and upsized each table, fixed
the errors and everything upsized correctly.
I will look into the DTS.
Thanks for your response and interest.
I am unsure as to why the data isn't converting on tables that don't have
errors?
WB
"Michael Shao [MSFT]" <v-yshao@.online.microsoft.com> wrote in message
news:HN61VeSfDHA.1544@.cpmsftngxa06.phx.gbl...
> Hi WB,
> This problem is wired. I would like you to provide more information so
that
> I can narrow down it?
> 1. Do you mean that there is not any error message?
> 2. Does this problem occur on SQL Server 7.0 or SQL Server 2000? What is
> the Service Pack of the SQL Server?
> 3. I would like you to try to upsize all the tables of the Access 2000
> database to SQL Server separately. Does the same problem occur again?
> 4. Please try to transform data from Access to SQL Server using DTS. For
> additional information regarding DTS, please refer to the following
article
> on SQL Server Books Online:
> Topic:" DTS Basics".
> Thanks for using MSDN newsgroup.
> Regards,
> Michael Shao
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
>|||Hi WB,
Thanks for your feedback. I glad to here that everything upsized correctly
now. Based on the information you provided, I am also unsure why the data
hasn't converted. To help me find out why, I would like you to provide more
information.
1. Do you mean the same problem occurs on both versions of SQL Server? If
so, what is the version of your Service Pack on both SQL Server (SQL Server
7.0 or SQL Server 2000)?
2. As I understand, the all structures of the tables have been upsized.
Only two of the tables have data and the other tables do not have any data.
If I have misunderstood, please feel free to let me know.
3. You wrote: "During this upsize I did have some errors. The problem
(errors) weren't specifically with the tables that didn't upsize the data."
Why do you think these errors are not related to this issue? Could you
please provide me with more details about the error message? If it is
possible, please provide me with a screenshot. You can send it to me
directly at v-yshao@.microsoft.com as an attachment.
4. I am not sure if this problem is machine specific. If it is possible,
could you upsize the MDB database from another machine? Can this problem be
reproduced on another machine? If this problem cannot be reproduced on my
side, it will be hard to find the cause.
Also, I found some useful articles regarding the issues with Upsizing
Wizard, could you check to see if your database has the same problem?
225993 ACC2000: Data Not Upsized in Table with Index
http://support.microsoft.com/?id=225993
325019 ACC2000: Issues with the Access 2000 Upsizing Wizard
http://support.microsoft.com/?id=325019
Thanks for using MSDN newsgroup.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.