Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SSMA for access

Status
Not open for further replies.
wellerw

wellerw

MIS
Mar 14, 2003
175
GB
HI,

I am trying to use the SSMA tool ver 4.0 to convert an Access 2007 database to my SQL 2005 std server.

The database appears to convert , but then gives errors saying that 'datatype "attachment" is not supported' , hence my columns with this datatype are not working.

does anyone know a way to convert the database and keep the attachment type?

Thanks
W
 
Status
Not open for further replies.

Similar threads

bethabernathy
  • Locked
  • Question
Front End Access 365 Database dsn Connection Fails when attempting to link to 2016 SQL server
Replies
1
Views
194
dhookom
dhookom
RRinTetons
  • Locked
  • Question
Tool for job scheduling
Replies
0
Views
157
RRinTetons
RRinTetons
duartevds
  • Locked
  • Question
Access SQL Server remotely from Another City 1
Replies
1
Views
92
gbaughma
gbaughma
Richard Parry
  • Locked
  • Question
Server to Server VPN for SQL Traffic
Replies
2
Views
82
Richard Parry
Richard Parry
antodanny
  • Locked
  • Question
Setting Up my Sql Server 2008 r2 DataBase for remote access through internet
Replies
1
Views
73
yelworcm
yelworcm

Part and Inventory Search

Sponsor

Back
Top