Basically I was creating a module and it wasn't creating any of the tables I had told it to set up in my .install file, and as far as I can see there weren't any mistakes.
What I found out was that because I had already installed and activated the module once, it wasn't re-running the install file and thus creating the tables.
All you have to do is disable the module AND uninstall the module. You will probably receive an error saying that it can't find the tables to remove but thats fine, thats the problem we are having!