** Reposted from MySQL Section**
Hey, I am having some problems with the Alter Table Function. The Error is as follows:
Microsoft JET Database Engine error '80040e14'
The database engine could not lock table 'tblFolders' because it is already in use by another person or process.
/upload.asp, line 106
The Code for line 106 is in bold
rsNewFile2.Open strSQL, adoCon
strFileID = rsNewFile2("FileID")
Set rsNewFile3 = Server.CreateObject("ADODB.Recordset")
strSQL = "ALTER TABLE tblFolders ADD [" & strFileID & "] varchar(10)"
Set rsNewFile3 = adoCon.Execute(strSQL)
This works once then when I try it a second time, it fails and gives me the error above. I can include more code if needed.