What is wrong with my memo fields

[Al]

I have been trying to upsize my Access2002 db to SQL.
Every time I tried, I got at the end the report showing me
that there was an error with one table and that table was
not upsized (the table was there in structure only but no
data). After so many attempts to upsize this particular
table to SQL I finally found out, through the process of
elemenation, that the cause of the problem was 2 memo
fields in that table. As soon as I took these 2 memo
fields out, the table was upsized no problem. I do not
know what is the problem with these 2 memo fields. I had
other tables with memo fields in the same db that were
upsized no problem. Any Ideas?
thanks
Al

 

[SFAxess]

It is possible that your SQL Server db was not set to
grow, and thus wasn't able to accomodate the size
increase for that table. The Access "memo" datatype's SQL
Server analogue, "text", takes up a lot more space in SQL
Server.

 

[AL]

How do I do that. and how come, other tables with memo
fields had no problems?
thanks
Al

 

[Al]

How do you set your SQL server DB to grow? and why other
table that had memo fields were upsized with no problem?
thanks
Al

 

[Guest]

How to set the sql db to grow?
How come the other tables with memo fields were upsized?
Al

 

[SFAxess]

You can set the file growth using the Enterprise Manager.
You can look at the properties of the database (right
click on the database in Enterprise Manager and
select "Properties") and check both the "Data Files"
and "Transaction Log" settings to see if it is set
to "Automatically Grow File", and that the maximum file
size is either "Unrestricted File Growth" or at a size
large enough to accomodate your needs ---Check with your
SQL Server DBA on what to set the size limit to.
If problems persist after setting the file growth
correctly, import the Access table in question using the
SQL Server tool, "DTS" (check Books Online for more info)
instead of the Access upsizing wizard for that one.
If that doesn't work, then you may wanna repost your
problem in this group and in a SQL Server group.
Best of Luck

 

[Al]

Thank you for responding. I am using the desktop (MSDE)
that comes with Access 2000 up. any idea?
Al