Discussion Locked

Null Row in DB. Help!!

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a VB 6 front end connected to Access 2000. I have
co-workers entering and editing records. Every now and
than a blank line appears. I have error handlers to avoid
any fields from being saved blank. I also
have .cancelupdate on the other events if someone starts
to add a record than changes their mind.What can I do to
prevent this?
.

3 replies

by peter ritchie

If you mark a fields as "Required" in the table design NULL values for that field cannot be added to the database.

This discussion is closed to new replies.