Failing to update dataset into access table. What am i doing wrong?

[CheshireCat]

I have added an access database into my 2005 desktop project, created a
dataset called ResourcesDataSe t which contains one of each table in the
database using the wizard. The database was automatically copied from its
source directory into my output directory. I connect to it using
Provider=micros oft.jet.oledb.4 .0
One of the tables is called server_id which i dragged from the dataset onto
my form.
Visual studio automatically generated server_idBindin gSource,
server_idTableA dapter, server_idBindin gNavigator and a data grid on my form.

To insert a record I use the following (server_id is a short, server_name is
a string.)
server_idTableA dapter.Insert(s erver_id, server_name);
I test server_idTableA dapter.GetData( ).Rows and find that the row's been
inserted there ok.
After all records are inserted, I call the following believing it's causing
a write to the database.
server_idTableA dapter.Update(r esourcesDataSet .server_id);
Checking the result of this, I'm receiving 0. The data isnt being committed.
If i check watch window for resourcesDataSe t.server_id, Count is only 1 (a
dummy record I entered directly into Access).
resourcesDataSe t.server_id.bas e.Rows.Count is also only 1.
This is the first time Ive ever used these components and the help files
were a bit sketchy.
What SHOULD I be doing please?

A second question.
For the server_id table, for example, I use access 2007 to create an access
2002-2003 mdb database and enter the fields in design mode.
There are 3 fields. ID which is defined as long, server_id which is defined
as an int, and server_name which is defined as a string.
When the database is imported into visual studio, ID becomes an int and
server_id is transposed into a short.
Why is this please?

thank you