#ERROR in table

[celltician]

I use MS Visual Basic 6.0 to add data to an MS Database.

Sometimes the program sends null's to all the fields and I get #ERROR in the field. (The table key is autonumber)
I cannot position on these or find a way to delete these without starting from scratch with a new database.
Any other way to do this?


Another question I just thought of:
I wrote a short module in Access to copy table defs to a new database. For each MyTable
copy the table definition to a new database
next
It tries to copy the hidden table objects! Is there a way around this?

Thanks.

 

[jca]

I have an answer for your second question.
Just check the attributes of the tables for the dbSystemObject flag with something like this:

For i = 0 To db.TableDefs.Count - 1
    if db.TableDefs(i).Attributes <> dbSystemObject then
       ' Do your stuff
    end if
next i

Hope this helps.