I make a copy of the dbc for each user. You can copy it into the user's temp directory when the system starts.

I usually deal with the NULL issue by replacing any empty date field with NULL before using TABLEUPDATE().

>I am creating a login screen to get userID and password,
>to use to connnect to a DB2 database from a VFP6.0 app
>If you use DBSETPROP(...) to set the userID and password
>programmatically after the user has input them in my custom
>login screen, the DBC must be opened exclusively
>Does anybody have any thoughts on ways to handle the
>login process?
>
>Also, has anyone had experience working with Date fields
>and dealing with Null values, with DB2 on the backend.
>If you have a grid with a date field column, setting a
>date to empty (ie 00/00/00) seems to be a problem.
>
>-tjm