locked
Error while exporting Access 2007 query and table to SharePoint 2007 site. Standard error of microsoft asking to close the program. RRS feed

  • Question

  • Hi All,

    When i am trying to export table or a query of Access 2007 to SharePoint 2007, i get error as :-

    Microsoft Office Access has encountered a problem and needs to close. we are sorry for inconvenience. Send error reports or do not send it.

    The other thing is i can very easily export it to excel and sql server. i get error only while exporting to SharePoint List.

    Please help.

    Your help is much appreciated.

    Thanks in Advance.



    Friday, July 22, 2011 11:07 AM

Answers

  • Hi manibal,

     

    There are many reasons that may cause this issue, it’s hard to definitely point out the reason.

     

    Please make sure that the steps you take to export Access table to SharePoint list are correct.

     

    Please do Office Repair and check. (Go to Control Panel->Uninstall a program->office, choose change, in the change installation of office page, choose Repare)

     

    If it persists, there is a confirmed issue similar to your scenarios that you may receive error message resembles the followingMicrosoft Access has encountered a problem and needs to close…”, which is fixed by the 2007 Microsoft Office suits Service Pack 1, you can try this to check.

     

    More information about “Export a table or query to a SharePoint Site”:

    http://office.microsoft.com/en-us/access-help/export-a-table-or-query-to-a-sharepoint-site-HA001230314.aspx

     

    Issues that are fixed in Access 2007 by the 2007 Microsoft Office suits Service Pack1:

    http://support.microsoft.com/kb/942378

     

    Thanks,

    Qiao Wei

    Monday, July 25, 2011 12:16 PM
    Moderator

All replies

  • Hi manibal,

     

    There are many reasons that may cause this issue, it’s hard to definitely point out the reason.

     

    Please make sure that the steps you take to export Access table to SharePoint list are correct.

     

    Please do Office Repair and check. (Go to Control Panel->Uninstall a program->office, choose change, in the change installation of office page, choose Repare)

     

    If it persists, there is a confirmed issue similar to your scenarios that you may receive error message resembles the followingMicrosoft Access has encountered a problem and needs to close…”, which is fixed by the 2007 Microsoft Office suits Service Pack 1, you can try this to check.

     

    More information about “Export a table or query to a SharePoint Site”:

    http://office.microsoft.com/en-us/access-help/export-a-table-or-query-to-a-sharepoint-site-HA001230314.aspx

     

    Issues that are fixed in Access 2007 by the 2007 Microsoft Office suits Service Pack1:

    http://support.microsoft.com/kb/942378

     

    Thanks,

    Qiao Wei

    Monday, July 25, 2011 12:16 PM
    Moderator
  • Thanks Qiao Wei for your reply.

    Will try with your options and keep you posted.

     

    Regards,

    Manish

    Monday, July 25, 2011 1:09 PM