Refresh links code does not run (2003)

Topic

New Reply

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?

Reply | Quote

Replies

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?

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

Reply | 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

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?

Reply | Quote