updating a blank field?

[spastica]

I am using ASP to update records in an Access database. If the db field has been previously populated, the update goes through without any glitches.

But, if the db field is blank/empty, and attempts are made to update it with a new value, it does not work.

I am not sure if this is an Access issue, but is it right to assume Access is glitchy when it comes to updating blank fields?

 

[WildHare]

But, if the db field is blank/empty, and attempts are made to update it with a new value, it does not work.

I am not sure if this is an Access issue, but is it right to assume Access is glitchy when it comes to updating blank fields?

Probably not. Despite it's many shortcomings, Access seems to have no problem updating a formerly null/blank/empty field to something non-null/not blank/not-empty, at least in my experience.

I'd check your update logic. It sounds like something is saying,"take this field's data and replace it with this stuff", and if there is no "field data", it's choking.

JMH





If at first you don't succeed, skydiving probably isn't for you!
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare.htm