Corruption of shared files on Citrix

#21

"David W. Fenton" <XXXusenet (AT) dfenton (DOT) com.invalid> wrote:

Quote:

I can't start forcibly closing applications on users. Remember,
users in this case are located all around the world--the Americas,
Europe, Australia, Japan, etc. It would be impossible to define
what "overnight" means.

There is no set time when you force the users to exit. It's a 30
or 60 minutes of inactivity that does it.

Well, perhaps that's how you do it, but I very plainly described
kicking them out at a particular time, in order that the back end be
free of users when the backup starts.

All of my clients pretty much run office hours or maybe a few hours into the evening
so that's not a big deal. But I see your point.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/

#22

On Jul 25, 4:49*pm, "Tony Toews [MVP]" <tto... (AT) telusplanet (DOT) net> wrote:

Quote:

"Bill E." <billmia... (AT) netscape (DOT) net> wrote:
Just to clarify, we have not had a corruption of the front end, only
the back end.

I don't think a shared FE could cause a BE to get corrupted although I suppose that's
possible.

FWIW at one client we logged all the folks as they entered the database and then
exited. * We'd been doing this for years and it was quite handy. *Forexample this
way we discovered that one printer driver in one dept was intermittently flaky and
would cause Access to crash. * Once IT put on the latest drivers all was well.

The client went with a load balancing Citrix farm and it would intermittently corrupt
the back end. *By the second or third time, by watching those who had logged in but
hadn't logged out, it was quite obvoius which one of the 4 Citrix serverswas causing
the corruptions. * Once it was removed/fixed/whatever no more problems.

For more information on corruption including possible causes, determiningthe
offending PC, retrieving your data, links, official MS KB articles and a list of
vendors who state they can fix corruption see the Microsoft Access Corruption FAQ athttp://www.granite.ab.ca/access/corruptmdbs.htm

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages -http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/
Granite Fleet Managerhttp://www.granitefleet.com/

maybe rare but, I've had a shared front-end on a server with the back-
end sitting in another folder on the same server and along comes a
user that opens a 'bound' form(add a new record) and lets it sit there
til closing time then just hits the power-off button on this pc and
bammmm! corupt back-end......... of course, he's no longer
living...

#23

bobh <vulcaned (AT) yahoo (DOT) com> wrote:

Quote:

I don't think a shared FE could cause a BE to get corrupted although I suppose that's
possible.

maybe rare but, I've had a shared front-end on a server with the back-
end sitting in another folder on the same server and along comes a
user that opens a 'bound' form(add a new record) and lets it sit there
til closing time then just hits the power-off button on this pc and
bammmm! corupt back-end.........

But that could've happened if each user had their own front end too. That's hard to
say.

Quote:

of course, he's no longer living...

<guffaw> Now there's the proper Access BOFH attitude!

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/

#24

bobh <vulcaned (AT) yahoo (DOT) com> wrote in
news:dc319b3c-925a-4b64-83b3-87c9700b16e6 (AT) e4g2000vbe (DOT) googlegroups.com
:

Quote:

On Jul 25, 4:49*pm, "Tony Toews [MVP]" <tto... (AT) telusplanet (DOT) net
wrote:
"Bill E." <billmia... (AT) netscape (DOT) net> wrote:
Just to clarify, we have not had a corruption of the front end,
only the back end.

I don't think a shared FE could cause a BE to get corrupted
although I su
ppose that's
possible.

[]

Quote:

maybe rare but, I've had a shared front-end

ALERT! Shared front ends are a problem, period, and shouldn't be
used at all. It wouldn't surprise me at all if the kinds of problems
that come from sharing a front end would cause Jet to be less stable
in interacting with the back end.

Only pure Jet objects can be shared safely, and while that includes
both tables and queries, only tables should be shared (mostly
because there's not much utility in storing queries in a back end).

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Corruption of shared files on Citrix

comp.databases.ms-access comp.databases.ms-access

Re: Corruption of shared files on Citrix - 07-27-2009 , 10:23 PM

Re: Corruption of shared files on Citrix - 07-29-2009 , 03:23 PM

Re: Corruption of shared files on Citrix - 07-29-2009 , 04:22 PM

Re: Corruption of shared files on Citrix - 07-29-2009 , 07:15 PM