I accidentally saved over a file and now I cant open the temp file.

If you saved over and then closed, it's gone permanently and there's no way to recover.

Is this what you're seeing?

This is a Photoshop scratch file, and you can't open those. It's not an image, it's Photoshop temporary working data, equivalent to a raw data dump from RAM.

Lots of people misunderstand Autorecovery. It's not backup, and it's not error recovery. It's purely for crash recovery. The contents of the autorecovery folder is deleted in a normal orderly shutdown. If Photoshop crashes, it will however be left behind. Photoshop looks in the autorecovery folder at every startup, and if there's something there, it's opened.

But normally there won't be anything there. In other words, there is no reason to look for recovery files. Either they come up automatically, or there's nothing there, it has already been deleted.

This is why we a) save incrementally, and b) have backups.

Why would you think you can open a temp file in Photoshop?

Photoshop creates a temp file while working (the scratch disk file) but that should be deleted when Photoshop is closed. It is not an image file.

Dave