Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2005

    Unanswered: Add forms to a replicated database

    I have replicated my database and have the master/slave. However i can't add any forms, reports, macros or modules to the slave. What should I have done to allow for this.

    Any help will be greatly appreciated.


  2. #2
    Join Date
    Nov 2007
    Adelaide, South Australia
    I don't use replication, so I could be wrong, but from what I understand the slave design can never be modified. You have to change the design master and "re-generate" the slave to change it.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Feb 2005

    Ad forms to replicated database

    That is true when it come to the tables and queries. But I do know that everthing else is not suppose to be replicated and that is where I am having my problem. I have doen this before but for the life of me I can't remember what i have to do to be able to add forms and reports to the slave.

  4. #4
    Join Date
    Dec 2004
    Madison, WI
    You'll have nothing but problems with replication. I've never seen it sucessfully implemented. After personally dealing with issues on it, I'd avoid it at all costs.

    The best advice I can give you is to keep a backup of your mdb (prior to the replication process - ie. not the master created from replication.) You'll need it often. There is a setting depending on the "node" you select which allows coding synchranizing and data synchranizing and I believe you set this when you create the slaves (or the master and the slaves). I gave up on replication over 8 years ago since it was such a pain in the #$$ to work with and I had to always re-create the master/slaves (from a backup before I started the whole replication process.)

    There's much, much easier ways! (ie. users connect in to your network that has the mdb file via citrix or vpn)
    Last edited by pkstormy; 06-18-09 at 21:09.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts