Access Database locked error

Question

So basically im processing data to a database from a textfile. When selecting 25 or more files the database starts locking up so in order to get all the data in the database I have to re-run over or process the files twice can some one tell me how to get rid of this error Im not for sure if its timing error or not

David Smith · Answer

Im using olebc connection instead. but in code when I try to increase timeout error  i get a syntax error. It says it cannot be assigned to because its read only how to fix this issue objconnection.Command.Timeout = 300; String strConnection = Properties.Settings.Default.CLU_OpDatabaseConnectionString; OleDbConnection objConnection = new OleDbConnection(strConnection); objConnection.ConnectionString = strConnection; objConnection.ConnectionTimeout = 300; objConnection.Open(); return objConnection;

David Smith · Answer

Im using olebc connection instead. but in code when I try to increase timeout error  i get a syntax error. It says it cannot be assigned to because its read only how to fix this issue objconnection.Command.Timeout = 300; String strConnection = Properties.Settings.Default.CLU_OpDatabaseConnectionString; OleDbConnection objConnection = new OleDbConnection(strConnection); objConnection.ConnectionString = strConnection; objConnection.ConnectionTimeout = 300; objConnection.Open(); return objConnection;

krishna prasad · Answer

Hai... Lemme give a sample Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:Table Normal; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:Calibrisans-serif; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Times New Roman; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:Times New Roman; mso-bidi-theme-font:minor-bidi;} String strconnect = server=Your server name;database=test;uid=stest;pwd=test ; Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:Table Normal; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:Calibrisans-serif; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Times New Roman; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:Times New Roman; mso-bidi-theme-font:minor-bidi;} try { SqlConnection con = new SqlConnection (strconnect); con.Open(); /*-----------------------Loading the dataset---------------------*/ SqlCommand command = new SqlCommand (); command.Connection = con; command.CommandText =  insert into test where id='1' ; command.CommandTimeout = 300; command.ExecuteNonQuery(); con.close(); } catch(Exceptionex) { Messagebox.show(ex.ToString()) } It's just a sample...fille in ur details like database name server namesql command u want to execute.... Hope this helps.. With Regards P.Krishna Prasad -------------------------------------------------------------------------------------------------------------------------- If someway my answer helped u don't forget to mark it as correct answer...

David Smith · Answer

How to get to the properties of the connection string to increase the timeout error

krishna prasad · Answer

Hai.... Increase the connection timeout of your connection string.connection timeout is a property to connection string... Increase it to a higher value.normally it's in milli seconds....... With Regards P.Krishna Prasad