Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2009
    Location
    Up Nort' Wi
    Posts
    140

    Unanswered: Remote accessing a split DB using Citrix

    Mornin'

    I'm having a massive brain derailment today so bear with me.

    With our current setup, about half of our people connect through a true split format (FE on local comp, BE on server), the other half connect through Citrix where the FE and the BE are both on the server. I don't *think* Citrix creates a new instance of the FE when they connect, which leads me to my actual question:

    How hard would it be to have our people connect through Citrix and have their own FE on their own local machines see the server held BE, instead of connecting and have 50+ people hitting the same FE?

    Is it something I can set up through VBA or can I make them a custom FE that is linked differently?

    Or am I making a mountain out of a molehill and Citrix creates a new instance of the FE when people log in?

    The way the current DB is now, we seem to be having way too many bizarre errors happening that can require recompiles/compact-repair during business hours (which requires calling all over the states to get people out of the db and then calling again to let them know when the maintenance is done)...and since I'm building the new DB from the ground up, I'd like to kill this issue at design/build time so it doesn't come back to bite me like it has the other DBA here.

    Thanks in advance,

    Sam, a networking specialist I ain't
    Good, fast, cheap...Pick 2.

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Check out the cloning file launching VBS topic in the Code Bank. I think it might have the answer you are looking for.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    http://www.dbforums.com/6274786-post19.html

    It's kinda heavy, but just check the script sample out and see what it's doing. It copies the front end at the server, so your 50 people all have their own FE, spawned off of the clean and compiled "original" FE. There are many other advantages to this, such as "auto rollout" of new versions.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Aug 2009
    Location
    Up Nort' Wi
    Posts
    140
    Excellent! Thank you, I'll check it out.

    Sam
    Good, fast, cheap...Pick 2.

  5. #5
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    You're not making a mountain out of a molehill. I had twitchy problems when Citrix users ran the same copy. What I did was to tweak my version control utility to look up the user and place the FE file in a folder unique to that user. IOW, where previously my utility would put a file on the user's PC at C:\AccessApps, it now places them in C:\AccessApps\UserName. That means each Citrix user is truly running their own copy.
    Paul

  6. #6
    Join Date
    Aug 2009
    Location
    Up Nort' Wi
    Posts
    140
    Cool, thanks...sounds like there are plenty of options out there...now they just need to decide it this thing's gonna be held on our Citrix controlled server...or as I found out today may be a possiblity: changed over to a web application.

    Thanks for the help you two, much appreciated.

    Sam, is it possible to have a nervous breakdown at 32?<g>
    Good, fast, cheap...Pick 2.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •