Problem running distributed application

[Knutjo]

I'm about to finish a VB6/Access2000 application and need some help with a problem when running the application.

After we have installed the program we tries to register a record in a form and gets an errormessage :

The field 'table.ID_field' cannot contain a Null value because the Required property for this field is set to True. Enter a value in this field.

The message is "wrong" because I have registered a value for the actual field in my form. I have been searching for the solution for hours and thought it must be some problem with the data access/connection and I decided to install only the "Data Access"-part from the VB6 CD on the customers computer. After that the application functions ok.

My question: What files are installed when you install only the "Data Access"-part from the VB6 cd ? (I need to implement those files in my InstallShield-script)

Regards
Knut

 

[CCLINT]

Go to the MS Data site and download MDAC 2.6 and Jet4.0 and include these in your setup.

 

[Knutjo]

Been there, done that !

Any suggestions ?

Regards
Knut

 

[CCLINT]

What type of field is ID_field defined as in the Database (text, number, auto-number)?

If Text or Number, click on the field name in design mode and look at the property "Required Field" at the bottom of the page and set it to "No"