Re: Queries - Back Ends and Replication
- From: John W. Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 08 May 2009 15:29:04 -0600
On Fri, 8 May 2009 13:16:30 -0700, Lori <Lori@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
Okay, Replication is something new to me. I've seen the posts about not
replicating the Forms and Reports. I did make that mistake and I understand
the reasons to keep them separate. However, this has generated several
questions.
1. Should I put my queries in the backend with my tables and if so would
they be link as well?
No. The backend should contain tables ONLY.
2. I like the idea of a replica because i can work on the master and not
have to worry about locking anyone out. If the forms and reports are not
replicated then that eliminates this benefit so why replicate at all?
These are completely unrelated issues.
It is not necessary (or appropriate!) to replicate in order to manage the user
interface (forms, reports, etc.); the only purpose of replication is to allow
users not connected to the database to update DATA in the table (in the
backend) independently, and have their updates of the data reconciled when
they reattatch to the database, or reconcile over the internet.
If you have a split database with nothing but tables in the backend, and only
links to the tables, forms, reports, etc. in the frontend, then you can freely
work on a "master copy" of the frontend on your own machine. Add new reports,
modify your forms, write queries, etc. - whatever is needed. When you're happy
with the new version, each user can simply delete their database (the frontend
contains no data so this does no harm) and replace it with the new version.
--
John W. Vinson [MVP]
.
- References:
- Queries - Back Ends and Replication
- From: Lori
- Queries - Back Ends and Replication
- Prev by Date: Re: Table design question re duplicates fields
- Next by Date: 66 Opinion de Dsiconsolas.com 41132
- Previous by thread: Queries - Back Ends and Replication
- Next by thread: 66 Opinion de Dsiconsolas.com 41132
- Index(es):
Relevant Pages
|
