<div>
<br />
Specify a Workgroup:<br />
&quot;C:\Program Files\Microsoft Office\Office10\msaccess.e<wbr />xe&quot; &quot;\\abc\workgroup\xyz\SomeD<wbr />atabase.md<wbr />b&quot; /wrkgrp 
</div>



Specify a Workgroup:
"C:\Program Files\Microsoft Office\Office10\msaccess.exe" "\\abc\workgroup\xyz\SomeDatabase.mdb" /wrkgrp

<div>
What are you trying to do? if you just want to connect to it, you can open an ADO or DAO connection.
</div>


What are you trying to do? if you just want to connect to it, you can open an ADO or DAO connection.

<div>
LSM,<br />
<br />
I want to fully open the database from a vbs script. The db is secured so I want to pass the users username and password to Access from the script.
</div>


LSM,

I want to fully open the database from a vbs script. The db is secured so I want to pass the users username and password to Access from the script.

<div>
The current desktop shortcut to the database uses the following for the target path:<br />
&quot;C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.E<wbr />XE&quot; /wrkgrp \\cotserver\vol1\departmen<wbr />ts\fire\da<wbr />tabases\ci<wbr />tyfire.mdw<wbr /> &quot;\\cotserver\vol1\departme<wbr />nts\fire\d<wbr />atabases\c<wbr />ityfire personnel.mdb&quot;<br />
<br />
The Start in box contains the following:<br />
\\cotserver\vol1\departmen<wbr />ts\fire\da<wbr />tabases<br />

</div>


The current desktop shortcut to the database uses the following for the target path:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /wrkgrp \\cotserver\vol1\departments\fire\databases\cityfire.mdw "\\cotserver\vol1\departments\fire\databases\cityfire personnel.mdb"

The Start in box contains the following:
\\cotserver\vol1\departments\fire\databases


<div>
<div class="content wysiwyg-content">
How do you open an Access database using vbs and specify a workgroup mdw file, username and password?
</div>
</div>


How do you open an Access database using vbs and specify a workgroup mdw file, username and password?

Open Access Database Using VBS

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.