Issue with Access 2010 hanging during create table query or export

[lsirakos]

I am trying to work with Access 2010 to do some pretty simple stuff. I have two tables, one with around 500k rows, the other with around 150k rows. There aren't too many columns, less or around 20 for each table.



I am just trying to do a simple inner join and then create a table but every single time I do it gets about 20% done on the status bar in the bottom right and just hangs. The query itself takes no time to run but it can't create it as a table. Same thing happens if I try to export the query.

Any ideas? This is driving me crazy, it should be something Access could handle with ease.

I should note this is a new computer and this is my first attempt with running Access on it. The processor and RAM are far in excess of what would be needed.

[RuralGuy]

Could it be data sensitive with the field you are joining on?

[orange]

You could post a copy of your database and the queries involved (remove anything confidential) and perhaps someone wll have a solution/answer.
Do you get any messages?