Mea Culpa, I am sure this issue is my doing as I was manually removing some things from the database using phpMySQL and reading some of the other threads I now know this can cause a problem. I have tried switching themes and deactivating some possibly conflicting plugins to no avail.
Now the forms are still present and they do have their data in the entries section and they still function in preview mode. However when inserted live, I get the "Oops! We could not locate your form." message.
Now I don't want to lose this data but it would not be the end of the world. I do however need my forms to be functioning correctly very soon. Any ideas? I would even be willing to completely remove and re-install if there is no other way. Please advise.