Open a DB in shared mode using call shell

E

Eric Blitzer

I posted this before but did not get a response
I use the below command to open another database from
another opened database. The problem is I get the error:
"You cannot open "db name" for exclusive use because
another use has the datbase open or you do not have
permissions to open exclusively.
Will open the datbase for shared access"

That is what I want to open it with shared access but I do
not want the error message. Can the below command be
modified or is there another way?

Call Shell("""C:\Program Files\Microsoft
Office\Office\Msaccess.exe""
c:\Mrs\Computer_Assistance_Request.mde /Runtime /Excl
/Wrkgrp \\Pghpart_DBMS\Mrs\System.mdw", 0)

Thanks

Eric
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OpenCurrentDatabase 1
Open Another Database in Read Only Mode 2
Open DB from another DB using shortcut work group 2
Access how to open existing database from another database using Access - VBA 0
Open exclusively with shell 1
shell command 2
Open DB not Exclusive Mode 2
shell to run another mdb 4

Top