FE/BE and Citrix

DavidB

OK guys I am in need of some assistance here. I have a standard FE/BE
database set up here. ABout 10-20 users have the FE installed on
tehir machines all linked to the common BE on the server. All
standard stuff. The network people are setting up some new
restrictions on the LAN and as a result they want to do the
following. I am not sure what the data risks are if any and how to
ensure that what they plan to do is 'safe'. They want to puit the FE
and BE on the server. Then use Citrix for each user to run the common
FE. Can y'all shed some light on this and give me any feedback as to
what concerns you might have if you were presented with this as the
current plan of attack?
Thanks,
DB

Jul 31 '07 #1

Arno R

"DavidB" <je***@yahoo.comschreef in bericht news:11*********************@e16g2000pri.googlegro ups.com...

OK guys I am in need of some assistance here. I have a standard FE/BE
database set up here. ABout 10-20 users have the FE installed on
tehir machines all linked to the common BE on the server. All
standard stuff. The network people are setting up some new
restrictions on the LAN and as a result they want to do the
following. I am not sure what the data risks are if any and how to
ensure that what they plan to do is 'safe'. They want to puit the FE
and BE on the server. Then use Citrix for each user to run the common
FE. Can y'all shed some light on this and give me any feedback as to
what concerns you might have if you were presented with this as the
current plan of attack?
Thanks,
DB

Looks like a bad idea, especially the 'use Citrix for each user to run the common FE' part.
Using Citrix is possible, but also with Citrix each user should have his/hers own FE.

The concern is corruption of course, but also if you are using temptables in the FE you will get *very* concerned....

So you will need about 10-20 FE's on that Citrix server (e.g. each in the user homedir).
Most networking guys don't like that. You will need to convince them.
A Google search on the topic will give you lots of information.

Arno R

Arno R

Jul 31 '07 #2

DavidB

On Jul 31, 12:01 pm, "Arno R" <arracomn_o_s_p_...@planet.nlwrote:

"DavidB" <je...@yahoo.comschreef in berichtnews:11*********************@e16g2000pri.go oglegroups.com...

OK guys I am in need of some assistance here. I have a standard FE/BE
database set up here. ABout 10-20 users have the FE installed on
tehir machines all linked to the common BE on the server. All
standard stuff. The network people are setting up some new
restrictions on the LAN and as a result they want to do the
following. I am not sure what the data risks are if any and how to
ensure that what they plan to do is 'safe'. They want to puit the FE
and BE on the server. Then use Citrix for each user to run the common
FE. Can y'all shed some light on this and give me any feedback as to
what concerns you might have if you were presented with this as the
current plan of attack?

Thanks,
DB

Looks like a bad idea, especially the 'use Citrix for each user to run the common FE' part.
Using Citrix is possible, but also with Citrix each user should have his/hers own FE.

The concern is corruption of course, but also if you are using temptables in the FE you will get *very* concerned....

So you will need about 10-20 FE's on that Citrix server (e.g. each in the user homedir).
Most networking guys don't like that. You will need to convince them.
A Google search on the topic will give you lots of information.

Arno R

Arno R

So the fact that this is running with the citrix piece in the puzzle
changes nothing about the common concerns of using a shared FE?

Can you give me few sites that discuss the issue of data corruption in
this sort of set up please?

Jul 31 '07 #3

Arno R

"DavidB" <je***@yahoo.comschreef in bericht news:11*********************@e9g2000prf.googlegrou ps.com...

On Jul 31, 12:01 pm, "Arno R" <arracomn_o_s_p_...@planet.nlwrote:

>"DavidB" <je...@yahoo.comschreef in berichtnews:11*********************@e16g2000pri.go oglegroups.com...

OK guys I am in need of some assistance here. I have a standard FE/BE
database set up here. ABout 10-20 users have the FE installed on
tehir machines all linked to the common BE on the server. All
standard stuff. The network people are setting up some new
restrictions on the LAN and as a result they want to do the
following. I am not sure what the data risks are if any and how to
ensure that what they plan to do is 'safe'. They want to puit the FE
and BE on the server. Then use Citrix for each user to run the common
FE. Can y'all shed some light on this and give me any feedback as to
what concerns you might have if you were presented with this as the
current plan of attack?

Thanks,
DB

Looks like a bad idea, especially the 'use Citrix for each user to run the common FE' part.
Using Citrix is possible, but also with Citrix each user should have his/hers own FE.

The concern is corruption of course, but also if you are using temptables in the FE you will get *very* concerned....

So you will need about 10-20 FE's on that Citrix server (e.g. each in the user homedir).
Most networking guys don't like that. You will need to convince them.
A Google search on the topic will give you lots of information.

Arno R

Arno R

So the fact that this is running with the citrix piece in the puzzle
changes nothing about the common concerns of using a shared FE?

Changes nothing indeed. Don't use a shared FE in a multi-user environment

Can you give me few sites that discuss the issue of data corruption in
this sort of set up please?

I don't know of sites about this, but it has been discussed very often here.
Please do the searching yourself...

Arno R

Jul 31 '07 #4

paii, Ron

"DavidB" <je***@yahoo.comwrote in message
news:11*********************@e16g2000pri.googlegro ups.com...

OK guys I am in need of some assistance here. I have a standard FE/BE
database set up here. ABout 10-20 users have the FE installed on
tehir machines all linked to the common BE on the server. All
standard stuff. The network people are setting up some new
restrictions on the LAN and as a result they want to do the
following. I am not sure what the data risks are if any and how to
ensure that what they plan to do is 'safe'. They want to puit the FE
and BE on the server. Then use Citrix for each user to run the common
FE. Can y'all shed some light on this and give me any feedback as to
what concerns you might have if you were presented with this as the
current plan of attack?
Thanks,
DB

The network people are under the mistaken assumption that the FE is loaded
for each user like a EXE. It does not, Access load each part of the FE as
needed keeping the MDB file open. Any unexpected shutdown of one of the
shared FEs can cause corruption. Temp tables in the FE will be shared by all
users. The issues are the same for Citrix / Terminal server as on a
workstation. They should follow or at least consider Microsoft's
recommendations just like they would when setting up other network
application.

Jul 31 '07 #5

Tony Toews [MVP]

DavidB <je***@yahoo.comwrote:

>So the fact that this is running with the citrix piece in the puzzle
changes nothing about the common concerns of using a shared FE?

Correct.

>Can you give me few sites that discuss the issue of data corruption in
this sort of set up please?

My random thoughts on Microsoft Access, Terminal Server and/or Citrix
http://www.granite.ab.ca/access/terminalserver.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Jul 31 '07 #6

DavidB

On Jul 31, 6:41 pm, "Tony Toews [MVP]" <tto...@telusplanet.netwrote:

DavidB <je...@yahoo.comwrote:

So the fact that this is running with the citrix piece in the puzzle
changes nothing about the common concerns of using a shared FE?

Correct.

Can you give me few sites that discuss the issue of data corruption in
this sort of set up please?

My random thoughts on Microsoft Access, Terminal Server and/or Citrixhttp://www.granite.ab.ca/access/terminalserver.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/

Thank you all for the input. I think this is ammunition enough that I
can now convince the powers that be to not go down the path they are
currently discussing.

Aug 1 '07 #7