ok, I'm trying to programatically update a front end. I have a database that checks it's version, if it is out of date, it should open a utility database to copy the new front end down to the user, that's where I start to run into problems.
I can never get the utlity database to open. when it gets to that section of code, access hangs and I end up having to kill it in task manager. Currently I'm using ShellExecute() to try to open the utlity database and I use docmd.quit to clost the current one. Now, if I run the code in a separate database, it all runs smoothly...
any help would be greatly appreciated.
edit:Never mind, I got it.
I can never get the utlity database to open. when it gets to that section of code, access hangs and I end up having to kill it in task manager. Currently I'm using ShellExecute() to try to open the utlity database and I use docmd.quit to clost the current one. Now, if I run the code in a separate database, it all runs smoothly...
any help would be greatly appreciated.
edit:Never mind, I got it.
Last edited: