Self teaching, cannot lock database file

[Michael Powell]

Hi,
I have been teaching myself C# and ASP, i wrote a sign-in and register
program to teach myself the use of SQL and databases using C# as the
development language.
Yesterday my little program worked a treat (except for the lack of error
handling), i came back to it today to complete it, and when i run the
program i get the following error:

Exception Details: System.Data.OleDb.OleDbException: Could not lock file.

Source Error:

Line 74:
this.oleDbCommand1.Parameters.Add("pass",OleDbType.Char).Value=this.TextBox2.Text;
Line 75: if(this.oleDbConnection1.State!=ConnectionState.Open)
Line 76: this.oleDbConnection1.Open();
Line 77: OleDbDataReader rdr=this.oleDbCommand1.ExecuteReader();
Line 78: if(rdr.HasRows)


does anyone know why this error occurs, or how to fix it.
(I don't actualy mind it not working, i just NEED to understand it!)
Any input would be most apprecciated

Mike Powell

 

[Guest]

What database are you using.

 

[Hans Kesting]

Hi,
I have been teaching myself C# and ASP, i wrote a sign-in and register
program to teach myself the use of SQL and databases using C# as the
development language.
Yesterday my little program worked a treat (except for the lack of error
handling), i came back to it today to complete it, and when i run the
program i get the following error:

Exception Details: System.Data.OleDb.OleDbException: Could not lock file.

Source Error:

Line 74:
this.oleDbCommand1.Parameters.Add("pass",OleDbType.Char).Value=this.TextBox2.Text;
Line 75: if(this.oleDbConnection1.State!=ConnectionState.Open)
Line 76: this.oleDbConnection1.Open();
Line 77: OleDbDataReader rdr=this.oleDbCommand1.ExecuteReader();
Line 78: if(rdr.HasRows)


does anyone know why this error occurs, or how to fix it.
(I don't actualy mind it not working, i just NEED to understand it!)
Any input would be most apprecciated

Mike Powell

I think this happens in Access, when you have a designer open.