Re: GUID default value

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

"Vladimir" <chvv@xxxxxxxxx> wrote in
news:1131461215.006761.292900@xxxxxxxxxxxxxxxxxxxxxxxxxxxx:

> 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?

There is only one kind of GUID field in Jet, and that is an
Autonumber GUID (called a "Replication ID").

I don't use Jet DDL since it's not as full-featured as DAO, so I
can't give you the Jet DDL to create an Autonumber field with
Replication ID as the Field Size.

I would point out that you are likely to have massive issues if you
try to use Access to connect to Jet tables with GUIDs in them, as
VBA and Access have major conversion problems with GUIDs, and the
default Access replication conflict resolver can't deal with them.
This iarticle outlines the basic problems:

Replication and GUIDs, the Good, the Bad, and the Ugly
http://trigeminal.com/usenet/usenet011.asp?1033

I have always completely avoided GUIDs in Access because of these
problems.

If, however, you are using pure Jet and not using VBA or Access at
all, the problems are much more manageable (though you're still
going to have to surmount the issues involved with whatever data
access interface you're using, ADO, DAO or ODBC).

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
.

Relevant Pages

  • Re: Replication or Synchronization -- How to?
    ... What is the best way to synchronize, and what can we do in the ... then forget it -- Jet ... Go to the Jet Replication Wiki and read all of it, ... With Access databases, it uses Jet replication, it just hides it ...
    (microsoft.public.access.replication)
  • Re: Run an access application as a service
    ... the aim of server replication is redundancy, ... databases. ... implementation - as one would expect from Jet vs SQL Server. ... While the mechanism for merge replication with Jet is certainly ...
    (comp.databases.ms-access)
  • Re: GUID default value
    ... > "Replication ID" field remained empty, although, I'd expect it to ... > have some value generated (a brand new GUID). ... handling the interface between connections and the data file. ... couldn't possibly expect Jet to provide triggers if you considered ...
    (microsoft.public.access.replication)
  • Re: GUID default value
    ... > We are developing a complex system, which will run on Oracle, MS SQL ... > All the databases are to be replicated. ... > GUID column, which is filled once a new record is inserted. ... Jet has a GUID data type. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: wie kann ich testen, ob WS.2k DC ist oder nicht?
    ... Active Directory Replication Monitor ... Replicated because the replication partner is a ring ... Partner GUID: 3655CE20-8859-403D-BEDC-40892F5D8201 ... Object GUID: 3655CE20-8859-403D-BEDC-40892F5D8201 ...
    (microsoft.public.de.german.windows.server.general)