Hello guys

I have been trying to find a solution for this problem in the last 3
days.

I have a secured Access database. This db contains a Macro that i will
like to run from Excel. I need the code to run the Macro from Excel.
Any ideas?

Thanks in advance

http://support.microsoft.com/kb/131921


On Mar 14, 6:18*pm, erick-flores wrote:
Hello guys

I have been trying to find a solution for this problem in the last 3
days.

I have a secured Access database. This db contains a Macro that i will
like to run from Excel. I need the code to run the Macro from Excel.
Any ideas?

Thanks in advance

Thanks for ur reply. But remenber I have a 'secured database'

I tried:
Private Sub Cmd_refresh_Click()
Shell ("C:\Program Files\Office97\Office\MSACCESS.EXE /excl /
NOSTARTUP /wrkgrp path_to_security.MDW path_to_database.mdb")
chan = DDEInitiate("MSACCESS", "system")
application.DDETerminate chan

And it looks like the Shell does not recognized with the .mdw option
on it. Any ideas how I can add the security file to the shell?

You might get more help in the Access newsgroup. Sorry.

microsoft.*public.*access.*modulesdaovba
microsoft.*public.*access.*externaldata

ps- why are you using Shell to automate MS Access? You could
instantiate it directly from Excel (by setting a reference to the
Access object library) and then manipulate Access objects from Excel.

--JP

On Mar 17, 3:36*pm, erick-flores wrote:
Thanks for ur reply. But remenber I have a 'secured database'

I tried:
Private Sub Cmd_refresh_Click()
* *Shell ("C:\Program Files\Office97\Office\MSACCESS.EXE * /excl /
NOSTARTUP /wrkgrp path_to_security.MDW path_to_database.mdb")
* *chan = DDEInitiate("MSACCESS", "system")
* *application.DDETerminate chan

And it looks like the Shell does not recognized with the .mdw option
on it. Any ideas how I can add the security file to the shell?

On Mar 17, 4:11*pm, JP wrote:
You might get more help in the Access newsgroup. Sorry.

microsoft.*public.*access.*modulesdaovba
microsoft.*public.*access.*externaldata

ps- *why are you using Shell to automate MS Access? You could
instantiate it directly from Excel (by setting a reference to the
Access object library) and then manipulate Access objects from Excel.

--JP

Well...I tried to used the link that you gave me, which references in
using Shell. I have tried using the Access object libraries but I cant
get it to work. My problem is that the database is secured, when I use
my code against a non-secured database everything works fine.

Thanks anyways.

Maybe this helps?

http://support.microsoft.com/kb/163002


--JP

On Mar 17, 6:29*pm, erick-flores wrote:

Well...I tried to used the link that you gave me, which references in
using Shell. I have tried using the Access object libraries but I cant
get it to work. My problem is that the database is secured, when I use
my code against a non-secured database everything works fine.

Thanks anyways.