SQL Alter Table Error

CHAINLINK_2006 · 10-10-2005, 11:11 PM

** 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

Code:

...
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.