Error 3163

[chriso0258]

I am running MS Access 2003 with SP3 on a Gateway MA6 laptop with XP Pro SP2. I am logged in as an administrator. Each day I am to log in my work orders in an Access database and then sync. with the Design Master which resides on a Netware server.

When I try to sync, I get the following error message:

"The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data. (Error 3163)
The field into which you tried to insert or paste data is not large enough to hold the data. Try inserting or pasting less data."

No one else has this problem. I've put the db in another folder and copied a known good db to my laptop and still have the same problem. I copied the design master db to my laptop and then immediately tried to sync. and got the same message. Unfortunately, the message does not tell me what field is too small. Any ideas?

 

[Remou]

Have you tried a compact and repair on your copy? Is it possible that you have a corrupt record?

 

[chriso0258]

Yes, but that did not work.

 

[Remou]

Can you compare the tables, or manually look at your tables to see if any record contains odd characters? This might also help:

Sub CheckForErr(tname)
Dim rs As dao.Recordset
Dim db As Database

Set db = CurrentDb

Set rs = db.OpenRecordset(tname)

With rs
   Do While Not .EOF
        For Each fld In rs.Fields
            If IsError(rs(fld.Name)) Then
               Debug.Print "Error"
            End If
        Next
        .MoveNext
    Loop
End With

'Debug.Print "Done"
rs.Close
Set rs = Nothing


End Sub

 

[chriso0258]

Thanks for your replies. Don't ask me why but the database is now synchronizing. Go figure. So, if it ain't broke anymore, I'm not going to try to fix it. Thanks again for your inputs.