"#Error"

From: Ng Man Ching <cs_nmc_at_cs.ust.hk>
Date: 10 Mar 1999 13:27:49 GMT
Message-ID: <7c5s0l$d39@ustsu10.ust.hk>

Hi all:

	I'm building a database for a company. The company has
        a Oracle 8 Server, I used Access to connect to the server
        . 
        After I create a Link-table to the table which stay in Oracle.
        and I find that whenever I try to input some data, all the
        data field in access will change to "#error".

        I used the following script to create the table in Oracle.

create table investigation
(

        casenum         char(20) not null,
        category        char(10),
        inward_date     date,
        incident_location varchar2(200),
        incident_datetime date,
        veh_num         char(6),
        veh_class       char(30),
        veh_type        char(20),
        info_name       char(50),
        info_phone      char(9),
        info_date       date,
        info_ref        char(20),
        reason          varchar2(200),
        vessel_reg      char(10),
        remark          varchar2(500),
        primary key(casenum)

);        Received on Wed Mar 10 1999 - 07:27:49 CST