import arcpy
arcpy.env.workspace = "C:/Users/dcheng/Documents/IDOP test/tables/IDOP_test.mdb"
hole_shp = "holes_leg1_leg96_fortest"
hole_shp_lyr = "holes_leg1_leg96_lyr"
arcpy.MakeFeatureLayer_management(hole_shp, hole_shp_lyr)
arcpy.SelectLayerByAttribute_management(hole_shp_lyr, "NEW_SELECTION", '[PK] = "1_5A"')
print "done"