Well after all this, i rechecked all of my paramenters before looking at creating an unbound form that sends the information to the tables via a button and i found that the problems came down to record-locking. I checked all the FE databases and found them all to be set to no locks, i then checked the BE database and it too was set to no locks. No problems here i thought but just out of curiousity i decided to reapply the settings to each of the databases. It worked, dont ask me why cause i dont know but now all my users can access and work in the database at the same.
Once again cheers to all you guys that tried helping me with this problem, You guys ROCK