MS Access Crashing

Anonymous
2017-10-03T16:00:50+00:00

I am going absolutely crazy trying to figure this out. Every time that I try to import Excel data into Access, I get the error 'Microsoft Access has stopped working.', it crashes and restarts Access. This happens in existing databases and brand new ones. I have tried all the 'Compact and Repairs' and everything else I can find on Google. I have even completely removed Office and reinstalled it. Still crashes. I HAVE to get this solved. I am working on a major project and will soon be to the point where I have to flush the testing data and import the real stuff. The problem is... I can't import ANYTHING. 

It also happens when I try to use various 'wizards'.

Any help would be greatly appreciated!!!

Thanks,

Jeff

<The thread has been moved to the correct category by forum moderator>

Microsoft 365 Insider | Access | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

11 answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2017-10-24T22:00:57+00:00

    I'm seeing it whenever I try to import data into Access 2016 from the External Data tab on the ribbon, regardless of file format.  If I open the same mdb in  MS-Access 2013, I can import the same data without incident. 

    Unlike many folks, I am running the 64-bit version of Office to allow for compatibility with other non-Microsoft applications required for my job.

    • MLC

    Was this answer helpful?

    0 comments
  2. Anonymous
    2017-10-04T15:54:25+00:00

    My bad, you are using the 64bit version of Access, so yeah the screen shot will help but I am using the 32 bit version where that appears.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2017-10-04T15:52:55+00:00

    Okay, now that is strange, can you please a screen shot of the External data tab.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2017-10-04T12:18:28+00:00

    I tried Safe Mode and lean Boot - no help.

    Office Version: Microsoft Office 365 Business Version 1710 (Build 8613.1000)

    Access Version: Microsoft Access 2016 MSO (16.0.8613.1000) 64 Bit

    OS: Windows 10 Pro

    Version: 1709

    OS Build: 16299.15

    Thanks for the help.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2017-10-04T11:50:27+00:00

    At least on my system, the Excel button on the 'External Data' tab is for Export, not import.

    Was this answer helpful?

    0 comments