Visual Basic ADO-trouble

Hello

I have some problem converting my VB-code from using MS Access to Microsoft
SQL 2000. I imported my Access-file into SQL Server and changed the
connecting-string which connects to the database. Reading entries from the
new location works perfectly fine. However adding new entries doesn't. I get
no errors what-so-ever. Nothing gets into the table.

Here is a part of the code:

'datTrackData is an ADODC-control.

strConnect = "server=(local);PROVIDER=SQLOLEDB.1;INITIAL
CATALOG=Airtools;Application Name = Airtools
Jingle;uid=Airtools;pwd=<removed>;"""
form1.datTrackData.ConnectionString = strConnect
form1.datTrackData.RecordSource = "select * from Trackdata Order by ID"
form1.datTrackData.Refresh

(...)

form1.datTrackData.Recordset.AddNew
form1.datTrackData.Recordset.Fields("Filename").Value = "Hello"

(...)

form1.datTrackData.Recordset.Save
form1.datTrackData.Recordset.UpdateBatch adAffectAll

This code (with another connectiongstring) works with MS Access but not with
MS Sql. Yep, I've checked the permission already.

Any ideas what might be wrong?

Regards
Eric Anderson