FP 2000 and access

T

Ted Ljong

Hi
I have an asp-page where I can change the fields in a record in a
membertable. Sometimes there are one or more fields that are empty for a
member. When I try to save the changed record I get this messages in FP:

Field 'fieldname' cannot be a zero-length.

I hope someone can help me with this problem
Thanks
Ted
 
T

Thomas A. Rowe

Open the database directly in Access (export to desktop first), select
table, switch to Design View, select field, then under the attributes at the
bottom, set to allow zero-length.

Then re-import back into FP.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle,
MS KB Quick Links, etc.
==============================================
 
Top