"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.