Error: The referenced account is currently locked out and may not be logged on to.

home computers (windows home) cannot join the domain, may receive the following error while accessing network drive:
The referenced account is currently locked out and may not be logged on to.
go to run, execute 'control password2' and modify credentials (usually password has been expired)

Error: InstallUtil. Installlog is denied

Error: InstallUtil. Installlog is denied - Log in as administrator or right click cmd and run as administrator

MS SQL - Round Decimal Down

MSSQL - Round Down
Round the following number 67.485000 to 67.480000
select ROUND(67.485000,2,1)

MS Access - Error: Query is too complex

divide existing query into multiple queries.  in my case I had 1 query that had union statement in it and another query that was calling the first one.  to resolve, divided first query into 2.