I got the silly thing to open. It turns out that I had set the controlsource to an alias rather than the table name.

Now my problem is that I keep loosing the connection between the grid and the table when the table closes. I tried the following solution in the spr but it caused an error:

MyGrid.RecordSource = .null.
append data from the array to the table
MyGrid.RecordSource = the table name

I know i'm close, but it is frustrating. Any help would be appreciated.