K
kkk via AccessMonster.com
I have created adp project with microsoft access 2000 frontend and sql server
200 backend. I am creating few stored procedures and views at run time
according to my business need. After creating them i am trying to open them
but i am having a error 'this object is not exist'. If i go to the database
window and click views and press f5 and then go to stored procedures window
and then press f5 then i can see them and able to open them. But users not
going to see the database window. how i can programmatically manage to
refresh database window so it doesn't complain about object not exist.
I have already tried
application.refreshdatabase window
but it does not work.
I have already tried
Application.Echo False
DoCmd.Hourglass True
SendKeys "{F11}", True
DoCmd.RunCommand acCmdViewStoredProcedures
SendKeys "{f5}", True
DoCmd.RunCommand acCmdWindowHide
DoCmd.Maximize
Application.Echo True
DoCmd.Hourglass False
but it gives me error "error 2046: The command or action
'viewstoredprocedures' isn't available now"
Please give me advise how i can fix this problem.
Thanks
200 backend. I am creating few stored procedures and views at run time
according to my business need. After creating them i am trying to open them
but i am having a error 'this object is not exist'. If i go to the database
window and click views and press f5 and then go to stored procedures window
and then press f5 then i can see them and able to open them. But users not
going to see the database window. how i can programmatically manage to
refresh database window so it doesn't complain about object not exist.
I have already tried
application.refreshdatabase window
but it does not work.
I have already tried
Application.Echo False
DoCmd.Hourglass True
SendKeys "{F11}", True
DoCmd.RunCommand acCmdViewStoredProcedures
SendKeys "{f5}", True
DoCmd.RunCommand acCmdWindowHide
DoCmd.Maximize
Application.Echo True
DoCmd.Hourglass False
but it gives me error "error 2046: The command or action
'viewstoredprocedures' isn't available now"
Please give me advise how i can fix this problem.
Thanks