Sorry, I cant really offer any suggestions here as Ive never owned an ACA card. It does sound like more of an ordeal than it should be. Ive never owned an accelerator that didnt just work when plugged in. Not to speak ill of efforts for new classic amiga hardware, but yours isnt the 1st problem Ive heard of for the ACA '030 cards. Having said that though Ive heard plenty of good reports too.
Hope Im mistaken, but so far this sounds a little worrying. The hardware simply shouldnt behave like this. From the contents of the thread thus far Id be inclined to think maybe you got a bad card. Or if the card isnt the problem then my next guess would be the trapdoor connector of your a1200 (although this seems less likely if it was a NOS a1200).
Anyway, good luck with resolving it, and I hope Im wrong with my assumptions, but by now Id be starting to think about returning the card for a new one.