Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Dec 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    421
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a split database that I am deploying in a terminal server/remote desktop setup. I created a function to run on startup that gets a path from a lookup table and refreshes the linked tables. This code is set to run in the Form load event of the startup form and works fine on my standalone PC at home. An error message like the attached appears. It appears the database is trying to look for these tables before the startup form since the path displayed is that from my computer, not the one entered in the paths table.

    I have never worked with terminal servers before so I don't know if it has something to do with that or is some other problem. Is there some way to have this relinking function run first thing when the database opens?
    Attached Images Attached Images

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='PeterN' post='761954' date='26-Feb-09 20:53']I have a split database that I am deploying in a terminal server/remote desktop setup. I created a function to run on startup that gets a path from a lookup table and refreshes the linked tables. This code is set to run in the Form load event of the startup form and works fine on my standalone PC at home. An error message like the attached appears. It appears the database is trying to look for these tables before the startup form since the path displayed is that from my computer, not the one entered in the paths table.

    I have never worked with terminal servers before so I don't know if it has something to do with that or is some other problem. Is there some way to have this relinking function run first thing when the database opens?[/quote]
    I didn't try it but I think it should work.
    Create an Autoexec Macro to execute the code and the last instruction of the code or the autoexec macro would be the instruction to open your startup form
    Francois

  3. #3
    4 Star Lounger
    Join Date
    Dec 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    421
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='Francois' post='761961' date='26-Feb-09 15:03']I didn't try it but I think it should work.
    Create an Autoexec Macro to execute the code and the last instruction of the code or the autoexec macro would be the instruction to open your startup form[/quote]

    That seems to work, but now I'm getting error 3011 which states that a table that exists doesn't exist. Also, I can run the code manually through the Login form where I originally had it and I have no problems there, only through the AutoExec. I did a web search and it seems to indicate corruption. Can anyone confirm this?

Posting Permissions

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