Hi,
I am trying to use SSMA for Access to convert a database from Access 2003 to Sql Server 2005. All the tables and views converted perfectly. But I have problem with all the Update Queries in the Access database. Neither of them becomes imported to Sql Server. I even wrote a very simple Update statement in Access, "UPDATE Hofors SET Hofors.Fadress = 'Babak' WHERE (((Hofors.SkrNr)='552793-9'));” to test but the result is same. I appreciate any help to solve this problem.
Best regards
/Babak
I am trying to use SSMA for Access to convert a database from Access 2003 to Sql Server 2005. All the tables and views converted perfectly. But I have problem with all the Update Queries in the Access database. Neither of them becomes imported to Sql Server. I even wrote a very simple Update statement in Access, "UPDATE Hofors SET Hofors.Fadress = 'Babak' WHERE (((Hofors.SkrNr)='552793-9'));” to test but the result is same. I appreciate any help to solve this problem.
Best regards
/Babak