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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Open Access database
- Thread starter lixie
- Start date
- Thread starter
- #3
OK, well I use this code to open a seperate dB and run it...
Dim strAccDB as String, strAccLoc as String
strAccDB = """" & "dBPath" & """"
strAccLoc = SysCmd(acSysCmdAccessDir) & "MSACCESS.exe"
Call Shell(strAccLoc & " " & strAccDB, vbMaximizedFocus)
Give it a shot, I'm just using "Shell" to open the dB, but the strAccLoc variable is set to the location of Access on the Machine (or on the server if you're running thin-client) so the Shell call can work. Kyle![[pipe]](/data/assets/smilies/pipe.gif "[pipe] [pipe]")
Dim strAccDB as String, strAccLoc as String
strAccDB = """" & "dBPath" & """"
strAccLoc = SysCmd(acSysCmdAccessDir) & "MSACCESS.exe"
Call Shell(strAccLoc & " " & strAccDB, vbMaximizedFocus)
Give it a shot, I'm just using "Shell" to open the dB, but the strAccLoc variable is set to the location of Access on the Machine (or on the server if you're running thin-client) so the Shell call can work. Kyle
- Thread starter
- #5
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question