I have a database called Schedule. Inside that database, I have two tables. One called LogonUser and another called Date. I'm trying to query the LogonUser Table so I can figure out what type of security the logged on user should have. This is what I have so far.
objConn.Open "Driver={SQL Server}; " & "Server=10.144.37.20;Database=Schedule;Uid=Intranet; Pwd=Password123;"StrSQL = "Select [Security] FROM dbo.LogonUser where [LogonUser] like 'MyuserId'"Set objConn.Execute (StrSQL)