Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
Thread: SQL Alter Table Error
10-11-2005, 12:11 AM #1
- Join Date
- Apr 2005
- Thanked 0 Times in 0 Posts
SQL Alter Table Error
** 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) ...