Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $95

Automating difficult table re-linking

Discussion in 'Information Technology' started by Graham R Seach, Jul 28, 2006.

  1. Graham R Seach

    Graham R Seach
    Expand Collapse
    Guest

    I have a scenario which is slightly different to the norm.

    I have several Access 2003 mdb, mde, adp and ade applications, which are
    being migrated to Citrix. I need to figure out a way to re-link the tables
    (Jet-->Jet, and DSN-->ODBC-->SQL Server 2000/2005) in a way that is reliable,
    automatic and transparent to the user.

    Both the production and development environments are going to be located
    within the same domain, but since this will be a Citrix server farm, the
    applications could be served from any server in the farm. That being the
    case, determining whether the front-end is launched from production or
    development, is tricky, because they're in the same domain, and the server
    names won't necessarily provide the right answer. Depending on current server
    load and redundancy issues, production and development could be on the same
    server, or different servers; there's no way to know ahead of time.

    Some of these applications employ ULS, and since most users don't have
    permissions on the tables, attempts at re-linking under their security
    context will fail. I don't want to use hard-coded filepaths for obvious
    reasons, so I'm thinking about switching Jet links to ODBC via DSNs.

    I know very little about how Citrix serves applications, or how it handles
    filepaths, registry entries, and so on. For reasons I won't go into (for
    brevity), the Administrators are not in a position to advise me about how
    they will be implementing production and development, or how they will
    differ. For me, this means I have nothing concrete I can use to determine the
    applications' status (prod or dev).

    If anyone has solved this scenaro in the past, I'd be grateful for any
    advice as to how you solved it. Otherwise, any good ideas would be most
    welcome.

    Regards,
    Graham R Seach
    (Stumped Access MVP)
     
  2. Loading...


Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page