Access 2000 upsizing trouble

  • Thread starter Thread starter WB
  • Start date Start date
W

WB

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 said:
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.
Click to expand...

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
 
Back
Top