Re: Access 2000 and empty fields

On Tue, 7 Nov 2000, Christopher R. Jones wrote:
> The same question comes up in the MySQL email list.  Apparently if you
> get the service pack for Office 2000 and the latest MDAC from the
> microsoft website, this problem is fixed. 

Thanks for the help.
I've installed Service pack SR1A for Access and installed the (almost)
latest MDAC (2.1SP2 I think). The only more recent version is the one that
comes with Win2K and isn't downloadable yet (2.5).

None of that made any difference though - I still get exactly the same
problem. 

Any other ideas?

> >In Access's table view, you can update fields of rows which contain no
> >empty fields fine.
> >
> >However, if any of the rows fields are empty, it won't let you change it
> >at all.
> >message box title: "Write Conflict"
> >description: "This record has been changed by another user since you
> >started editing it.  If you save the record, you will overwrite
> >the changes the other user made." 

-- 
Phil Davey 
http://www.pod-designs.net/philandjo.html 
E-mail pod@pod-designs.net                          ICQ 46295740
Just because you're smart, doesn't mean you can't act stupid....