Replication: What objects can I replicate?

  • Thread starter Thread starter Tom Allen
  • Start date Start date
T

Tom Allen

I have split my database into a frontend and backend. I
am currently replicating the backend to 10 workstations
on the network. My question is this: Can I replicate
forms, reports, and queries as well? I have been told
that you should not replicate these objects - only
tables - but no one can explain why. I need to distribute
changes to these objects quite frequently and it is a
pain to do it manually on 10 workstations. Any ideas or
suggestions?

Tom
 
Personally, I get the users to download it themselves by automatically
checking the version when they startup the application. If they are using an
old version, pop a message & boot them out.

To do this, I simply created a Version table, which I log any changes that I
make. I then set the Startup-Application Title to this version & have a
small piece of code which compares the two...

There is a good document here regarding replication:
http://support.microsoft.com/default.aspx?scid=/support/access/content/repl/replovrvw.asp



--
Cheers,


James Goodman MCSE, MCDBA
http://www.angelfire.com/sports/f1pictures
 
If all your workstations are on a LAN, why replicate? You can put the
backend on the server, and each user can have a copy of the frontend (linked
to the one backend).

Design changes to forms/reports may not propagate to the replicas.
Replication is meant for data only. I believe this is covered in the
Replication FAQ.

If you are making changes to the frontend and need to then distribute it to
the users, there are methods to automate this. Tony Toews has a tool.
Check out auto frontend updater at his site.
http://www.granite.ab.ca/accsmstr.htm
 
Thanks for the link - I'll check it out. I originally had
the configuration you described in place about a year ago
and had slow response and record lock problems. The
current configuration works just great - replication
manager would be a nice addition though. I just cant
convince myself that I need to spend $500 plus on a
developers kit just to get replication manager. Wish you
could purchase replication manager by itself.
Thanks,
Tom
 
Back
Top