locked
Access To SQL Mgration Assistant Table Creation Problem RRS feed

All replies

  • Hi cevvo,

    The link you provided is not accessible (Maybe blocked by the company network).Could you please upload it on another shared folder like 'Skydriver'.

    And it will be more helpful if you could provide more information about how you got the error message.

     


    Best Regards,
    Peja

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Thursday, October 6, 2011 7:50 AM
  • Hi cevvo,

    You could import that table into a stand-alone Access database.
    Then you could use either SSMA or built-in MS Access Upsizing wizard to upsize that single table.

    If you managed to upsize then there could be problems with relationships on that table.

    Otherwise, look at properties of each column, for example Format.


    Sergei
    Thursday, October 6, 2011 8:17 AM
  • Hello Guys

    Here is the lnk below. There is no relationship among my tables because of no unque id I have...

    https://skydrive.live.com/?cid=1C63F509BC419FD6&id=1C63F509BC419FD6%21114

     

    Regards,

    Cevvo

    Thursday, October 6, 2011 2:14 PM
  • Hi Cevvo,

    Is it non-English version of Access?


    Sergei
    Thursday, October 6, 2011 7:52 PM
  • Hi Cevvo,

    The error 'Invalid object name 'tac.dbo.***' may have the below causes:

    1.the user you are connecting as does not have SELECT, UPDATE, INSERT, DELETE, EXEC permissions on the object;
    2.you aren't logging in / connecting as the user you expect;
    3.you are referencing the object without an owner name prefix (or with the wrong owner name);
    4.you are connected to the wrong database;
    5.you are, in fact, spelling the object's name incorrectly.
     

    And could you view table like 'tac.dbo.t_00_form_perm' in SQL Server ? If you use schemas you may want to read about user-schema separation in SQL Server .(http://msdn.microsoft.com/en-us/library/ms190387.aspx)

    Hope this helps,


    Best Regards,
    Peja

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Proposed as answer by Peja Tao Wednesday, October 12, 2011 9:23 AM
    • Unproposed as answer by cevvo Wednesday, October 12, 2011 11:50 AM
    Friday, October 7, 2011 1:46 AM
  • Hi Colleagues,

    I couldn't figure the matter out indeed.. Can you have a check by linking attached database to MSSQL?

    https://skydrive.live.com/?cid=1c63f509bc419fd6&sc=documents&uc=1&id=1C63F509BC419FD6%21114#


    By the way I use English version of :

    MS Access 2010 SP1 (with latest updates)
    SQL Server 2008 R2 SP2 (with latest updates)

     

    Thank you

     


    • Edited by Cevatyildiz Friday, October 7, 2011 11:13 AM
    Friday, October 7, 2011 11:10 AM
  • Nobody can tell me what is wrong with this database?
    Wednesday, October 12, 2011 8:43 AM
  • I have checked all possiblities concerning username. I can easily create tables in MS SQL server, but SSMA can not create tables in MS SQL with same login name.

     

    Wednesday, October 12, 2011 11:13 AM
  • Can you try using Profiler to capture what SSMA executes against SQL Server and what the error is?
    Hope it helps.
    Sunday, October 16, 2011 10:07 AM
  • Hi Jim,

    Can you check result.rar. If anybody can help by connecting my computer by teamviewer, I'll be glad... Thank you

    https://skydrive.live.com/?cid=1c63f509bc419fd6&sc=documents&uc=1&id=1C63F509BC419FD6%21114#

     

    Sunday, October 16, 2011 4:25 PM