Mine was the same. I popped the bottom of the door panel off, pulled up some insulation, and manually pushed the window up from the bottom. It held for the drive back from the beach at least.

Here is your special window band-aid.