Hello all,
Here is a snippet of my code can someone help me in adjusting it to have the access database open exclusively please
Dim db As Database Dim ws As Workspace Dim rs As Recordset Dim r As Long Set ws = DBEngine.Workspaces(0) Dim Wks As Worksheet Set Wks = Worksheets("CE") 'On Error GoTo ErrHandler: Set db = ws.OpenDatabase _ (Sheet2.Range("A30"), _ False, False, "MS Access;PWD=q1w2e3r4")
Bookmarks