Open up your databases panel and double click on the connection you are using. Click on the test button and see if the connection is being created correctly. If it is not, then make sure the information is correct.
Also, what is the exact error message you are getting when you try to create a recordset. Is it when you open up the recordset panel or is it after you hit ok to insert it?