vbscript open access db and execute sub

[Auto]

Hi,
i am having an access db that is basically to update alot of stuff inside of linked tables, and some more stuff, i wrote a vbscript file that should open the access db if its closed, and execute the sub named UpdateController.
the issue is that if there is no other instance of access it works fine, but if i am having another access db opened, then it throws an Error that it cant find the procedure, i had looked around all over on the web, cant find any solution to this one, please if anyone could help, i would really appreciate.

here is the vbscript code.

on error resume nextdim accessApp
set accessApp = GetObject("C:\Feeds\UpdaterApp.accdb")
if err.number = 0 then
err.clear
set accessApp = createObject("Access.Application")
if err.number = 0 then
err.clear
set accessApp =  GetObject( , "Access.Application")
end if


accessApp.visible = true
accessApp.UserControl = true
accessApp.OpenCurrentDataBase("C:\Feeds\UpdaterApp.accdb"), false
end if
on error goto 0




accessApp.Run "UpdateController"

BASIC FACTS.
1) my module name is not the same as my procedure name.
2) my procedure is declared public.


3) its not in a class module, just inside a regular module.
4) it only occurs if another database is opened at the same time.

any help on that?

thanks in advanced.

[rpeare]

if the only purpose of the updaterapp is to run a section of code why don't you just create a form and attach the code to the ON OPEN event of that form and set the form to be opened when the database is opened, then all you have to do is call the database to be opened, it runs, then shuts itself down.