Many Errors Generated from Access 2007 -> SQL Server 2008 Express

[Alex]

I'm trying to upsize an Access database to SQL 2008 using SSMA and the
process has generated many errors and warnings. The most prevalent ones are:
"Type <> not converted"
"External Variable not Converted"
and lots of
"Invalid Object Name"

The "type" that is not converted is mostly "Binary" (with the caps B),
however binary is defined in the type mapping tab.

I did not build the initial Access database and I am new to SQL and Access,
but I've been given this job. Any help will be greatly appreciated. Are there
any resources that have the solutions to these generated errors available?
Thanks for your help.

~Alex

[Gina Whipp]

Alex,

While I have not tried Access 2007 was curious what are the Invalid Object
names? Also, what is in your Binary field? While it say it is allowed, if
memory serves me and at my age it could be failing, it still must be in a
certain format.
--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Post by Alex
I'm trying to upsize an Access database to SQL 2008 using SSMA and the
"Type <> not converted"
"External Variable not Converted"
and lots of
"Invalid Object Name"
The "type" that is not converted is mostly "Binary" (with the caps B),
however binary is defined in the type mapping tab.
I did not build the initial Access database and I am new to SQL and Access,
but I've been given this job. Any help will be greatly appreciated. Are there
any resources that have the solutions to these generated errors available?
Thanks for your help.
~Alex