Ok I figured it out. I created and empty database and made it so it is in 2003 formatting. Then I took the tables from the database I was having the problems with and importing them into the new 2003 formatted database. Then I imported all forms,reports,and querys into the 2003 access database and to my amazement it worked. I then continued to split my database and my frontend that was created in 2010 works with the backend tables and  my other front end that was created in 2003 also works with my tables. Still dont know why it was working at home with 2007 but not at work. The only thing I can see that was different was when I created the database orginally
was the buttons were raised and some I made glow which works with my orginal but was not carried into the 2003 tranformation.

               On a side Note: Thank You Mr.Rost from all your classes. I have learned a great deal about access and I continue to keep learning. Thanks Again

---

Reply from Richard Rost:

Awesome. I'm glad you got it working. Yeah, Access 2007 had a bunch of glitches in it that I don't think were ever fully fixed. 2010 is much better.