updating ade across domains

I am working on an ADP for my company.  It links into a MS SQL Server 2000 database.  I currently use SQL authentification because this adp is going to be used on two different domains.  I have my own login in form and everything works great. I can log in with no problems even across domain.  What i am working on now is an update procedure.  My company does not have control of the domains and not many people have accounts on both domains.  The problem i am having with updating is that if I make a new version of the ADP(which will be an ade when it is released) i will have to store a full copy of the ade in 2 different locations, one for each domain and then program it to look in different locations.  what i came up with was to save all forms,module,repots as text and load them into a table on the server.  when it is time to update the update procedure will just download the new text file and create a new adp on the fly with the new text files and then covert the new adp into an ade with accmdmakemdefile.  however none of this works.  the only thing i have ben able to get work is to save the text files into a table.  i cannot create a new mdb, or i can but i cannot use loadfromtext on that mde remotely.  also the accmdmakemdefile gives me a "This action was canceled" error.  I am open to any suggestions or help.  I am desperately ready to get this adp out there so people will stop calling me for the reports that it creates.  Start Free Trial