Entering data into access database

First, note that there are various ways of creating a connection string so that ADO and/or VS prompts us for the parameters. There are a few articles in this web site about doing that.

It is possible to create a data source in VS that will generate code that makes it easier to manipulate data in a table. It does require some learning but when you know how to do it the better way, you won't need to waste time with details. There are basically two ways to create a data source; either TableAdapters or Entities.

Have a look at my Database Table Update in a DataGridView without Writing Code; it describes creation of a TableAdapter data source. It does not describe how to use TableAdapters for manipulating data but TableAdapters can be useful for that.

There are other articles in this web site about Entities. If the articles are not enough, then it will help to get a book about database programming.

It is useful for you to learn about SqlConnection and the other ADO classes. Just understand that you don't need to be concerned about detailed classes such as that if you create a data source and manipulate the data with it.

The problem was using the wrong type of connection. sql rather than access it now works. to some extent :P

This is the code now (at the bottom)
Sam, If there are better ways of doing things I am very interested though. I am just learning at the moment so want to avaoid bad habbits early on ideally.

Basicly im just trying to manupulate data in a table at the moment.

  private void button1_Click(object sender, System.EventArgs e)
  {

   string istring = @"INSERT INTO tblUsers(username, distance) VALUES('Test',121);";

   OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=L:\BDSU\Archive\Personal - TO BE SORTED\Scott Thurlow\InTheDistance.mdb; User Id=admin; Password=;");
   conn.Open();

   OleDbCommand cmd = new OleDbCommand(istring, conn);

   cmd.ExecuteNonQuery();
   conn.Close();
  }

check the working code for me

problem is with this line i think.....

new SqlConnection(@"Data Source=L:\testing\in the distance\ITD.mdb");

place it under app_data and right click on mdb file and copy the file address...
use that as connectionstring....

sqlconnection sqlconn=new sqlconnection(fileaddress).........

use this directive System.Data.Sqlclient....or System.Data.Oledb;

but check if mdb file has any access rights........

One other thing.

In your 'using' directives, you'll need to change this line:

using System.Data.SqlClient;

to this:

using System.Data.OleDb;

so the compiler will be able to find the correct classes.

It looks to me as though your connection string is difficient.

If you're using MS Access, I'd try this instead:

SqlConnection conn = new SqlConnection(@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=L:\testing\in the distance\ITD.mdb; User Id=admin; Password=;");

What is the size of the distance field? If it is INTEGER, then as I remember, it is only 2 bytes in length, so you can't insert 54321.

Try the same statement but only limiting the value to something smaller, e.g. this:
string istring = @"INSERT INTO tblUsers(username, distance) VALUES('Test',100);";

Zoran