ACCESS FEED: RE: [MS_AccessPros] Re: Citrix vs. Desktop environment

It's the same thing essentially, but what might be a difference here is that the cmd file run behind the citrix htm link will copy out the latest and greatest front end. That way I can deploy an update and just tell the user to get out of the db and get back in to the db and they'll get the newest mods.

I think you could do the same thing if you have on their desktop a bat file that copies the newest accde out from a network drive.

Liz Ravenwood
Database Developer / Programmer
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of giorgio_rovelli
Sent: Wednesday, September 14, 2011 12:50 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Citrix vs. Desktop environment

What are the advantages of having Access frontends and backends in Citrix rather than, e.g., using Access runtime on the desktops and the backend accdb/mdb on a server disk?
Giorgio

--- In MS_Access_Professionals@yahoogroups.com, Liz Ravenwood <liz_ravenwood@...> wrote:
>
> Good come back!
>
> Liz Ravenwood
> Database Developer / Programmer
> Super First Class Products
> B/E Aerospace
> O: 1.520.239.4808
> www.beaerospace.com
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of giorgio_rovelli
> Sent: Wednesday, September 14, 2011 12:15 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: Citrix vs. Desktop environment
>
> I take it Jack is the Citrix guy ;-)
> Giorgio
>
> --- In MS_Access_Professionals@yahoogroups.com, Liz Ravenwood <liz_ravenwood@> wrote:
> >
> > Now we're in to territory that I don't know.
> >
> > The citrix gateway calls some type of citrix script (which I am not privy to) which opens the html, which opens the cmd, which opens the accde, which holds the wall that Jack built. Hee hee!
> >
> > Liz Ravenwood
> > Database Developer / Programmer
> > Super First Class Products
> > B/E Aerospace
> > O: 1.520.239.4808
> > www.beaerospace.com
> >
> >
> > -----Original Message-----
> > From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of giorgio_rovelli
> > Sent: Tuesday, September 13, 2011 3:51 PM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: [MS_AccessPros] Re: Citrix vs. Desktop environment
> >
> > Thanks Liz,
> > What do you do with that html file?
> > Giorgio
> >
> > --- In MS_Access_Professionals@yahoogroups.com, Liz Ravenwood <liz_ravenwood@> wrote:
> > >
> > > Giorgio - here's the bit that calls the cmd:
> > >
> > > <p class=MsoNormal style='text-align:justify'><![if !vml]><img width=19 height=19
> > > src="tu_db_portal_files/image003.jpg" align=left alt=MSAccessIcon v:shapes="Picture_x0020_67"><![endif]><span
> > > style='mso-spacerun:yes'> </span><a href="../FE_CMDs/FE_SB.cmd">Service
> > > Bulletins</a></p>
> > >
> > >
> > > Liz Ravenwood
> > > Database Developer / Programmer
> > > Super First Class Products
> > > B/E Aerospace
> > > O: 1.520.239.4808
> > > www.beaerospace.com
> > >
> > >
> > > -----Original Message-----
> > > From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of giorgio_rovelli
> > > Sent: Tuesday, September 13, 2011 12:00 PM
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Subject: [MS_AccessPros] Re: Citrix vs. Desktop environment
> > >
> > >
> > > Hi Liz, that's very interesting.
> > >
> > > you say, "For the citrix gateway, our citrix guy gave me access to a doc
> > > file that I save as an html file with hyperlinks that copy the front end
> > > out to their individual h: drives."
> > >
> > > your script looks like a batch file, may I ask where the html is in it?
> > >
> > > Giorgio
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, Liz Ravenwood
> > > <liz_ravenwood@> wrote:
> > > >
> > > > Lee,
> > > >
> > > > Here is what the script looks like:
> > > >
> > > > @echo off
> > > > REM This script will copy the needed files for TU DBs if not present
> > > and then launch application from H:\
> > > >
> > > >
> > > > If not exist "H:\TUDBs" md "H:\TUDBs"
> > > >
> > > > xcopy /y
> > > "\\WS0111\TUSiteInfo$\Databases\DBFrontEnds\FE_PanelKits.accde"
> > > "H:\TUDBs\"
> > > >
> > > > START MSACCESS.EXE H:\TUDBs\FE_PanelKits.accde
> > > >
> > > > EXIT
> > > >
> > > > Liz Ravenwood
> > > > Database Developer / Programmer
> > > > Super First Class Products
> > > > B/E Aerospace
> > > > O: 1.520.239.4808
> > > > www.beaerospace.com
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: MS_Access_Professionals@yahoogroups.com
> > > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz
> > > Ravenwood
> > > > Sent: Tuesday, September 13, 2011 10:27 AM
> > > > To: 'MS_Access_Professionals@yahoogroups.com'
> > > > Subject: RE: [MS_AccessPros] Re: Citrix vs. Desktop environment
> > > >
> > > > Lee,
> > > >
> > > > I run Access 2007 in a Citrix environment and don't have any issues,
> > > other than the user experiencing slow network and thinking it is the
> > > database instead.
> > > >
> > > > For the citrix gateway, our citrix guy gave me access to a doc file
> > > that I save as an html file with hyperlinks that copy the front end out
> > > to their individual h: drives. When I deploy a new database I can just
> > > edit the file, make the cmd, hyperlink it out, and voila.
> > > >
> > > >
> > > > Liz Ravenwood
> > > > Database Developer / Programmer
> > > > Super First Class Products
> > > > B/E Aerospace
> > > > O: 1.520.239.4808
> > > > www.beaerospace.com
> > > >
> > > > -----Original Message-----
> > > > From: MS_Access_Professionals@yahoogroups.com
> > > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Lee
> > > > Sent: Tuesday, September 13, 2011 9:58 AM
> > > > To: MS_Access_Professionals@yahoogroups.com
> > > > Subject: [MS_AccessPros] Re: Citrix vs. Desktop environment
> > > >
> > > > I should append this to say that we are looking for any issues that
> > > may come up with troubleshooting/maintenance/general operation, that
> > > don't factor in the citrix environment itself (IE is the problem in
> > > Citrix or is it Access related). That part is obvious to us, but
> > > apparently our tech guys don't understand.
> > > >
> > > > --- In MS_Access_Professionals@yahoogroups.com, "Lee" leevt99@ wrote:
> > > > >
> > > > > Hi,
> > > > > Our company is moving to office 2007 (finally), however, not all
> > > divisions are doing so, and some people will still be on office 2002/03.
> > > > >
> > > > > We are trying to get a spare computer set up with an XP environment
> > > for troubleshooting/maintenance purposes for those customers, however
> > > our tech department is insisting they install access 2002/03 on citrix,
> > > and there will be no differences for us when it comes to
> > > troubleshooting.
> > > > >
> > > > > I have a feeling this is not the case. Can anyone think of anything
> > > specific that would make working exclusively in a citrix environment
> > > less desirable than having a PC set up with an XP environment?
> > > > >
> > > > > Our database setups are all a standard front end/interface connected
> > > to a shared back end, including the ones we have on citrix.
> > > > >
> > > > > Thanks
> > > > > -Lee
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > > ------------------------------------
> > > >
> > > > Yahoo! Groups Links
> > > >
> > > >
> > > >
> > > >
> > > > This email (and all attachments) is for the sole use of the intended
> > > recipient(s) and may contain privileged and/or proprietary information.
> > > Any unauthorized review, use, disclosure or distribution is prohibited.
> > > If you are not the intended recipient, please contact the sender by
> > > reply e-mail and destroy all copies of the original message.
> > > >
> > > >
> > > >
> > > > ------------------------------------
> > > >
> > > > Yahoo! Groups Links
> > > >
> > > >
> > > >
> > > >
> > > > This email (and all attachments) is for the sole use of the intended
> > > recipient(s) and may contain privileged and/or proprietary information.
> > > Any unauthorized review, use, disclosure or distribution is prohibited.
> > > If you are not the intended recipient, please contact the sender by
> > > reply e-mail and destroy all copies of the original message.
> > > >
> > >
> > >
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Yahoo! Groups Links
> > >
> > >
> > >
> > >
> > > This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> > This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
> This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
>

------------------------------------

Yahoo! Groups Links

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.