Postresql + Access

[PlayDoh]

Hey there folks!!

I have written a psql d-base for my boss and used Access 97 as a front end for and connected it with an ODBC. All my fields work correctly except for my Boolean field. PSQL will only accept it as a 1 or 0 whereas access accepts it as a 4 (field size) so when I try to click on the check box within Access it tells me the field size is too small to accept the inputted data. The data type (range) within Access cannot be changed at all. Is there anything I can write just for that Boolean within Access?
Hope someone can help!!

Also, on an unrelated subject, is there a quick VB code that will stamp an actual field within Access with the date the record was entered? i.e. If I am entering a clients information and just want the date to be stamped into a field named stamp_date automatically is there an easyish way to do that?

[This message has been edited by PlayDoh (edited 11-10-1999).]

[JHausmann]

1) you could try defining the field as an integer field (in PSQL) and leaving it as a boolean in Access (the values will be stored as -1 or 0 in PSQL).

2)issue an sqlexecute and update the field with something like:

"update table set date_field=#" & Date & "# where some_condition=unique"

Note: I have no experience with PSQL