How to open a secured Access db from Excel
 

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

How to open a secured Access db from Excel
 

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

How to open a secured Access db from Excel
 

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?

How to open a secured Access db from Excel
 

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?

How to open a secured Access db from Excel
 

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.

How to open a secured Access db from Excel
 

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.

How to open a secured Access db from Excel
 

Maybe this helps?

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


I forgot to mentioned that my database has user-level security. I have
already looked at the link you gave me, but that one works with
secured database. If you read number 3 under the Summary section it
says:
"Open the database. Note that opening a secured Access database is
different from opening a database that is secured with the Microsoft
Access user-level security feature."
So this will not work for me. Sorry for my lack of information.

Anyways thanks for ur replies, if you still have any more links out
there please let me know...I am going crazy trying to figured this one
out.

How to open a secured Access db from Excel
 

Sorry, my lack of familiarity with Access is showing. Again you might
want to post your query in the Access ngs:

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


--JP

On Mar 18, 3:26*pm, erick-flores wrote:
Maybe this helps?

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

I forgot to mentioned that my database has user-level security. I have
already looked at the link you gave me, but that one works with
secured database. If you read number 3 under the Summary section it
says:
"Open the database. Note that opening a secured Access database is
different from opening a database that is secured with the Microsoft
Access user-level security feature."
So this will not work for me. Sorry for my lack of information.

Anyways thanks for ur replies, if you still have any more links out
there please let me know...I am going crazy trying to figured this one
out.

How to open a secured Access db from Excel
 

No prob. Thanks for ur help