about using MS-Access

Question

User-1588418485 posted

hi guys....can we write stored procedures in ms-access 2007...if possible how?

Answer 1

User-1199946673 posted

No, in Access Stored pocedures are not supported. You can only create single SQL statement and store them as Saved Query. In .NET, you can use those query just like Stored Procedures

Answer 2

User954927490 posted

stored procedure can not be created in access 2007. you will have to use sql query for this.

if you want the syntax  for this this is below:
using System.Data.OleDb;


OleDbConnection con=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=" + HttpContext.Current.Server.MapPath("App_data\\yourdb.mdb"));

if (con.State == ConnectionState.Open)
{
con.Close();
con.Open();
}
else
{
con.Open();
}


OleDbCommand cmd = new OleDbCommand();
cmd.CommandType = CommandType.Text;
cmd.Connection=con;
  cmd.CommandText = "insert into tablename (columnname1) values (@Type)";
cmd.Parameters.Add(new OleDbParameter("@Type", "Bnr"));
cmd.ExecuteNonQuery();
cmd.Cancel();
cmd.Dispose();
 

Answer 3

User-1199946673 posted

stored procedure can not be created in access 2007

 

That's correct

you will have to use sql query for this.

Like I said, you can use saved queries like they are a Stored Procedure

cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "name of saved query";