replicating forms

[gyang]

I created a replica of a database using
"Tools-->Replication-->Create Replica...".

The replicated database replicated tables and queries, but the forms and reports didn't get relicated.

So I went into forms and did
"File-->Get External Data-->Import" and try to import the forms in. It let me import, but for each form it said something like object already exist, but there were no forms or at least I didn't see them in the forms section. I clicked okay and imported them anyway.

Then when I try to open them, it wouldn't open in either form view or design view and their was not an error message about "can't modify because you are not the design master. . ." It didn't do anything.

Do forms and reports not replicate?

Thanks.

 

[Alexandre]

In theory they can be replicated. However, in practice replication applied to DB objects others than TableDefs and the data inside is a far too unreliable and heavy process (especially when involving forms, reports and modules).

MS itslef ackowledges that fact in its white paper on replication (a must read) and recommends the classical approach:

• Split your DB FE/BE (BE with only tableDefs and data, FE with everything else plus eventually a few tables that should not be replicated)
• Replicate only your BE

 

[gyang]

Okay, thanks. I'm new to replicating, but I'll give it a try with the FE/BE splitting.

When you say modules, do you mean macros? I noticed some of the macros didn't get replicated as well. (sorry, this follow-up question should probably be in the Macros discussion).

 

[Alexandre]

No, I mean modules. With VBA code, not macros. However, you can very probably extend that no-no advice to macros, pages and queries...