Re: Replicas
From: Cheval (NoSpam.Ask_at_ForEmail.com)
Date: 02/09/05
- Next message: Jackie Reyes via AccessMonster.com: "Re: Replicas"
- Previous message: Jackie Reyes via AccessMonster.com: "Replicas"
- In reply to: Jackie Reyes via AccessMonster.com: "Replicas"
- Next in thread: Jackie Reyes via AccessMonster.com: "Re: Replicas"
- Reply: Jackie Reyes via AccessMonster.com: "Re: Replicas"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 09 Feb 2005 21:33:08 GMT
The undocumented first rule with Access Replication: Only Replicate Tables.
Split the database into two files any only replicate the backend (tables
only file). Copy the front end (Queries, Forms, Macros, Modules) to each
user.
One more thing, a little word of advice, don't let the users modify the
front end. Really! Give them a "play" front end of their own to use to their
desire.
In my systems I have two database front ends that they can open. The main
standard one for data maintenance, standard reports, etc and a personal play
one that sits in their home folder. The standard one checks for the latest
version of itself and downloads and opens it. The users personal play one
links to the same replicated backend file tables as the standard one so they
can do anything that want. eg, In the play database they can create
temporary and customised tables, queries, reports, etc. They can even import
a standard report form the main database front-end, customise it for their
personal needs and then even delete it from their play database again
without worrying about wrecking anything.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
"Jackie Reyes via AccessMonster.com" <forum@AccessMonster.com> wrote in
message news:767dd0ccd46c4b1abd8c1154c50d0bab@AccessMonster.com...
Hello,
I've replicated my database and realized that there may be some limitations
for the users of a Replica. I have made several reports, queries, and
macros in the Design Master and synchronized it to the replicas. However, I
noticed that in the Replica, a user can't make any kind of changes to any
of the reports. Is there a way to override this? I want to allow the users
the ability to make changes themselves.
-- Message posted via http://www.accessmonster.com
- Next message: Jackie Reyes via AccessMonster.com: "Re: Replicas"
- Previous message: Jackie Reyes via AccessMonster.com: "Replicas"
- In reply to: Jackie Reyes via AccessMonster.com: "Replicas"
- Next in thread: Jackie Reyes via AccessMonster.com: "Re: Replicas"
- Reply: Jackie Reyes via AccessMonster.com: "Re: Replicas"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
