Greetings

We are developing a complex system, which will run on Oracle, MS SQL
Server and MS Access databases. All the databases are to be replicated.

We are using a single common database scheme. For each table we have a
GUID column, which is filled once a new record is inserted. We have
default values for the GUID column in Oracle DB and MS SQL.

Could you please tell me which is the correct column data type for GUID

in MS Access and how can we set a default value for the column?

Here is a sample for MS SQL Server

create table PRODUCT_SRC (
  ID                   int                  identity,
  CR_OPE_ID            int                  null default
dbo.GET_CURRENT_USER_ID(),
  OPE_ID               int                  null default
dbo.GET_CURRENT_USER_ID(),
  CH_DATE              datetime             not null default
GETDATE(),
  CR_DATE              datetime             not null default
GETDATE(),
  STATUS               char(1)              not null default 'A',
  GUID                 uniqueidentifier     not null default newid(),
  NAME                 varchar(100)         not null,
  constraint PK_PRODUCT_SRC primary key  (ID)
)
go

and Oracle

create table PRODUCT_SRC  (
  ID                   INTEGER                         not null,
  CR_OPE_ID            INTEGER,
  OPE_ID               INTEGER,
  CH_DATE              DATE                            default SYSDATE

not null,
  CR_DATE              DATE                            default SYSDATE

not null ,
  STATUS               CHAR(1)                        default 'A' not
null,
  GUID                 RAW(32)                         default
sys_guid(),
  NAME                 VARCHAR2(100)                   not null,
  constraint PK_PRODUCT_SRC primary key (ID)
);

Thanks, Vladimir.