Hello !<BR><BR>--------------------<BR>I am using:-<BR><BR>Win2000 , Access 2000 , FP2000<BR>My role - as a adminstrator with full permission<BR>Server & Database has got full read /write permissions<BR>-------------------------<BR>Code lines having problems are :-<BR><BR>Line 57 --&#062;set connNews = Server.createobject("ADODB.Connection")<BR>Line58 ---&#062;strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&<BR>Server.MapPath("news.mdb")<BR>L ine 59 ---&#062; connNews.open strDSN<BR>Line 60 ---&#062;connNews.Execute("INSERT into Article ( Art_Date, Art_Title,<BR>Art_Body, Art_URL, Art_Live ) SELECT #" & Date() & "# as mDate, &#039" & mTitle<BR>& "&#039 as Title, &#039" & mBody & "&#039 as Body, &#039" & mURL & "&#039 as URL, " & True & "<BR>as Live;")<BR>--------------------<BR>Errors getting :-<BR><BR>(1) When using strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&<BR>Server.MapPath("news.mdb")<BR>< BR>"Microsoft OLE DB Provider for ODBC Drivers (0x80004005)<BR>[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable<BR>query.<BR>/Lab3/WebNews/NewsAddArticle.asp, line 60"<BR><BR>(2) When using strDSN ="PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver<BR>(*.mdb)};DBQ=" & Server.MapPath("news.mdb")<BR><BR>"Microsoft OLE DB Provider for ODBC Drivers (0x80004005)<BR>[Microsoft][ODBC Microsoft Access Driver]General error Unable to open<BR>registry key &#039Temporary (volatile) Jet DSN for process 0x400 Thread 0x4dc<BR>DBC 0x13ce54c Jet&#039.<BR>/Lab3/WebNews/NewsAddArticle.asp, line 59"<BR><BR>(3) When using strDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= "&<BR>Server.MapPath("news.mdb")<BR><BR>"Micro soft JET Database Engine (0x80004005)<BR>The Microsoft Jet database engine cannot open the file<BR>&#039c:inetpubwwwrootLab3WebNews
ews.mdb&#039. It is already opened exclusively<BR>by another user, or you need permission to view its data.<BR>/Lab3/WebNews/NewsAddArticle.asp, line 59"<BR>-----------------------------<BR><BR>Thanks,<BR>A.K.Jain(akj@usa.com)<BR><BR><B R><BR><BR><BR>