In the field of nonlinear optical (NLO) materials research, the design and synthesis of novel materials are crucial for advancing modern scientific and technological development. This study employs an innovative coordination strategy, building upon the existing structure of [Ln2(CH3COO)6(H2O)4]·4H2O (Ln = Tb, Sm), to successfully synthesize a series of acetate rare-earth metal compounds [Ln2(CH3COO)6(H2O)]n [Ln = Tb(1), Er(2), Y(3)] by regulating the number of water molecules. This approach achieved a structural transition from centrosymmetric (CS) to noncentrosymmetric (NCS), endowing these compounds with significant nonlinear optical responses. We discovered that reducing the coordinated water molecules and introducing acetate as a bidentate ligand is an effective method for modulating crystal structure and realizing NLO performance. This finding not only deepens the understanding of the structure of acetate salts but also provides important theoretical and experimental support for the development of materials with potential NLO propeties.