E
Erik T
I receive the follow message:
The database engine could not lock table 'SQL_ClassDif' because it is
already in use by antoher person or process.
Here is the code that is generating the error
strSQL = "SELECT SQL_P3.HN, SQL_P3.HORSENAME, SQL_P3.PROGRAM, " & _
"SQL_P3.P1Avg, SQL_P3.P1Rank, SQL_P3.P2, SQL_P3.P2Rank, " & _
"TEMP_Class_DifRank.Class_DifRank " & _
"INTO SQL_ClassDif " & _
"FROM SQL_P3 " & _
"LEFT OUTER JOIN TEMP_Class_DifRank ON SQL_P3.HN =
TEMP_Class_DifRank.HN"
DoCmd.RunSQL (strSQL)
The table SQL_ClassDif is used by queries that were not written in VBA but
from the Access menu. I still need the other queries to be able to access
this data. Can you offer any workarounds for me?
Thank you
The database engine could not lock table 'SQL_ClassDif' because it is
already in use by antoher person or process.
Here is the code that is generating the error
strSQL = "SELECT SQL_P3.HN, SQL_P3.HORSENAME, SQL_P3.PROGRAM, " & _
"SQL_P3.P1Avg, SQL_P3.P1Rank, SQL_P3.P2, SQL_P3.P2Rank, " & _
"TEMP_Class_DifRank.Class_DifRank " & _
"INTO SQL_ClassDif " & _
"FROM SQL_P3 " & _
"LEFT OUTER JOIN TEMP_Class_DifRank ON SQL_P3.HN =
TEMP_Class_DifRank.HN"
DoCmd.RunSQL (strSQL)
The table SQL_ClassDif is used by queries that were not written in VBA but
from the Access menu. I still need the other queries to be able to access
this data. Can you offer any workarounds for me?
Thank you