Just heard that Austrade will not support a dB that is modified in this way - the only alternative is to merge the data - will check this out. Many thanks Rob On Tue, Jun 24, 2008 at 9:39 AM, Berny Stapleton <berny@xxxxxxxxxxxxxxxxx> wrote: > Umm, what about a user dsn, set in a registry key? The app would make > a call to a dsn, it couldnt determine user from system could it? Get a > test instance and try a user dsn and see if it works. > > Berny > > On 6/24/08, Greg Reese <gareese@xxxxxxxxx> wrote: > > it's a shame they hard code it. Multiple DSN's would do the trick for > you. > > > > On Mon, Jun 23, 2008 at 6:00 PM, StGeorge <wcsconnect@xxxxxxxxx> wrote: > > > >> Good Morning, > >> > >> We have a client running an Aust trade db Application. The application > >> uses > >> a System DSN to talk to an access db. > >> We require for good governance to run a separate db for each state, does > >> anybody have any ideas as to get round this > >> problem? Currently if we change the DSN to point to Victoria then all > >> users > >> get the Victoria db and similar for QLD. > >> I was thinking of changing the DSN on the fly but I am not sure if the > >> application after locating the db would continue using the DSN, > >> this would cause a corruption with users updating the wrong db. The DSN > >> is > >> hard coded in the the application. > >> > >> They are running a single 4.5 Adv Citrix server. > >> > >> Regards > >> > >> Rob > >> > > > > -- > Sent from Gmail for mobile | mobile.google.com > ************************************************ > For Archives, RSS, to Unsubscribe, Subscribe or > set Digest or Vacation mode use the below link: > //www.freelists.org/list/thin > NEW! Follow Thin List on Twitter! > http://twitter.com/thinlist > Thin List discussion is now available in blog format at: > http://thinmaillist.blogspot.com > HOT! Thinlist MOBILE Feed! > http://thinlist.net/mobile > Thinlist quick pick > http://thinlist.net > ************************************************ >