I have a SQL Server 6.5 database that has been linked as tables into an
Access 97 MDB file.  The MDB file has additional tables that are specific
to the workstation.  From the VB 5 application i use the data control to
access the Linked table in the MDB file.

Whenever i perform a .Addnew or  .update i get a type mismatch error but
the
program functions without a problem even after the message.  

I have a piece of code that shows this : I have marked the error zones with
the >> mark.  I am trying to populate a network architechture as a tree
from a database.  It also occurs at regions after this wherever i use the
.Addnew... in the function.

But when i try to use the Access 97 form to enter sample data into the sql
database - i do not get these errors.

Thanks for the help

Madhu
PS: Please reply to both newsgroup and me. I work using a slow link

-----------------------------------------------------------
Public Sub AddServer(ServerType As String)

    Dim ServerName As String
    Dim ActiveSite

    ServerName = InputBox("Server Name", "Add Server")
    If Len(ServerName) > 0 Then

         With datTopology.Recordset  

    End If

End Sub
--------------------------------------------------------------------------