By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,070 Members | 1,237 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,070 IT Pros & Developers. It's quick & easy.

Citrix and replication

P: n/a
Hello,

We are currently running our Access 2003 database over Citrix. We have
been using a single front-end, but reading over topics in this group
has made it clear that I should create separate front-ends for each
user...so I will do so...thanks to this group for the great research.

My question: on occasions, staff have to access the database and they
will not have a network connection. I am considering setting up
replication manager to handle this. Are there any problems using
replication manager in a Citrix environment?

p.s. I had posted other questions yesterday but I felt that this was a
separate topic so have started a new thread - I hope this is okay.

Thanks very much,
Alexandra

Jun 21 '06 #1
Share this Question
Share on Google+
6 Replies


P: n/a
"Alex" <db*********@yahoo.com> wrote in
news:11**********************@u72g2000cwu.googlegr oups.com:
We are currently running our Access 2003 database over Citrix. We
have been using a single front-end, but reading over topics in
this group has made it clear that I should create separate
front-ends for each user...so I will do so...thanks to this group
for the great research.

My question: on occasions, staff have to access the database and
they will not have a network connection. I am considering setting
up replication manager to handle this. Are there any problems
using replication manager in a Citrix environment?


Using replication in a Terminal Server scenario is no different at
all than using it in a non-TS situation.

If you think there is some difference, then you likely have
misconceptions about how replication works, or about how you should
be setting up your front end/back end.

Ask some specific questions. That's likely to get you a more
specific answer.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Jun 21 '06 #2

P: n/a
"Alex" <db*********@yahoo.com> wrote in
news:11**********************@u72g2000cwu.googlegr oups.com:
My question: on occasions, staff have to access the database and
they will not have a network connection. I am considering setting
up replication manager to handle this. Are there any problems
using replication manager in a Citrix environment?


And, BTW, there is no need for replication manager unless you need
indirect replication. That's only needed when the remote users
cannot connect directly to the LAN on occasion to do their synchs,
or you want them to regularly synch across a WAN/Internet
connection.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Jun 21 '06 #3

P: n/a
I am sorry David, but I am getting a little confused.

Our back end and front ends are located on a server, not on the local
laptops. So how can the users access the database when they have no
network connection?

Alex.
David W. Fenton wrote:
"Alex" <db*********@yahoo.com> wrote in
news:11**********************@u72g2000cwu.googlegr oups.com:
My question: on occasions, staff have to access the database and
they will not have a network connection. I am considering setting
up replication manager to handle this. Are there any problems
using replication manager in a Citrix environment?


And, BTW, there is no need for replication manager unless you need
indirect replication. That's only needed when the remote users
cannot connect directly to the LAN on occasion to do their synchs,
or you want them to regularly synch across a WAN/Internet
connection.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/


Jun 23 '06 #4

P: n/a
"Alex" <db*********@yahoo.com> wrote in
news:11**********************@p79g2000cwp.googlegr oups.com:
David W. Fenton wrote:
"Alex" <db*********@yahoo.com> wrote in
news:11**********************@u72g2000cwu.googlegr oups.com:
> My question: on occasions, staff have to access the database
> and they will not have a network connection. I am considering
> setting up replication manager to handle this. Are there any
> problems using replication manager in a Citrix environment?


And, BTW, there is no need for replication manager unless you
need indirect replication. That's only needed when the remote
users cannot connect directly to the LAN on occasion to do their
synchs, or you want them to regularly synch across a WAN/Internet
connection.


I am sorry David, but I am getting a little confused.

Our back end and front ends are located on a server, not on the
local laptops. So how can the users access the database when they
have no network connection?


Then I don't at all understand what role replication would play at
all. Why would you replicate data that exists in only one place? Do
you have multiple Citrix servers at different locations? If so, why?
Why not just have one -- if you did that, you'd have a single back
end shared by all, and no need to worry about all the issues raised
by replication.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Jun 23 '06 #5

P: n/a
Sorry if I have not been clear before.

So, we have a multi-user database which is used via Citrix. So one back
end and a bunch of front ends. It works well when all our users are in
the office.

My challenge: on occasions our users are using the database in areas
where they cannot get a network connection. So they need to be able to
access the database offline and then have their changes uploaded to the
master database when they come back to the office.

In the past, to get around this issue, we have been moving the database
onto the users laptop and then it is moved back to the Citrix server
when they return to the office. This does mean, obviously, that no
other user can access the database in the interim.

So, I am trying to figure out a way for our users to have access to the
database when they are out of the office (in an area where there is no
internet connection, such as on a pool deck - the database is used for
entering swim results).

So, I was thinking of using replication and creating a bunch of
replicas which would be loaded onto the laptops. It is not my first
preference since we have used replication in the past and I found it
high maintenance.

So my questions were:
1. If we do set up master/replicas and replication manager; I guess
this will do away with the need for using Citrix??
2. Is there any other way for users to access the database offline?

Again I thank you for your time and patience!

Alexandra
David W. Fenton wrote:
"Alex" <db*********@yahoo.com> wrote in
news:11**********************@p79g2000cwp.googlegr oups.com:
David W. Fenton wrote:
"Alex" <db*********@yahoo.com> wrote in
news:11**********************@u72g2000cwu.googlegr oups.com:

> My question: on occasions, staff have to access the database
> and they will not have a network connection. I am considering
> setting up replication manager to handle this. Are there any
> problems using replication manager in a Citrix environment?

And, BTW, there is no need for replication manager unless you
need indirect replication. That's only needed when the remote
users cannot connect directly to the LAN on occasion to do their
synchs, or you want them to regularly synch across a WAN/Internet
connection.


I am sorry David, but I am getting a little confused.

Our back end and front ends are located on a server, not on the
local laptops. So how can the users access the database when they
have no network connection?


Then I don't at all understand what role replication would play at
all. Why would you replicate data that exists in only one place? Do
you have multiple Citrix servers at different locations? If so, why?
Why not just have one -- if you did that, you'd have a single back
end shared by all, and no need to worry about all the issues raised
by replication.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/


Jun 23 '06 #6

P: n/a
"Alex" <db*********@yahoo.com> wrote in
news:11**********************@g10g2000cwb.googlegr oups.com:
So my questions were:
1. If we do set up master/replicas and replication manager; I
guess this will do away with the need for using Citrix??
There is no need for replication manager. If your users are
connecting directly to the LAN when the return to the office, you
can use direct replication, which can be accomplished with one line
of code (well, you'll need to add some other lines of code to make
sure that single line can work, but it's a total of about 15-20
lines of code, including checking for conflicts, if you want to).

Replication Manager is not even needed for doing indirect
replication, though it makes it easier to set up and use certain
features.
2. Is there any other way for users to access the database
offline?


Not that I know of.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Jun 23 '06 #7

This discussion thread is closed

Replies have been disabled for this discussion.