Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Open a password protected database

Status
Not open for further replies.

cassie99

Programmer
Dec 20, 2001
26
US
Hello,

The code below successfuly opens a remote database. Is there an option that I can add to the path that opens XP_Foo.mdb if it is password protected? Thanks in advance.

Cassie

<SNIP>
Dim strAccDB As String
Dim strAccLoc As String

strAccDB = """" & "\\CRBL0F01\137\DQA_Time\XP\Management\XP_Foo.mdb" & """"
strAccLoc = SysCmd(acSysCmdAccessDir) & "msaccess.exe"
Call Shell(strAccLoc & " " & strAccDB, 1)
DoCmd.Quit acQuitSaveAll
<END SNIP>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top