Open a DB in shared mode using call shell

  • Thread starter Thread starter Eric Blitzer
  • Start date Start date
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
 
Back
Top