ProductProperties Not Showing in Actinic

[Spitos]

When I have lots of products to add, I create them in a separate site and paste them into our live site. I do this because our live site is so large and has so many products that even clicking between one and another involves waiting for around 30 seconds for what i have clicked to be selected.
I have never had any issues doing it this way before.

I have 10 new products that I have created and added all of the info and properties to the section and product. When I paste them into the live site, everything EXCEPT the product properties is carried over in Actinic.

If I go to the access database, all of the data is there in the database but it is not showing in Actinic. Does anyone know why or how to get the data that is in the database to show?

I want to add again that this method has always, always worked without fail before and the data is in the database.

[Duncan Rounding]

Did you try compacting the database?

[Spitos]

Yep, I've tried doing that on both databases from both within actinic and in access too just to make sure!