Re: DB2, MsSQL, and MS Access, How to maintain 3 data sources

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

Don't seem to be a good idea to use GUID.
He will have to change the data structure for all his tables and databases,
and all the applications that have been designed to use against these
databases.



"William (Bill) Vaughn" <billvaRemoveThis@xxxxxxxxxx> wrote in message
news:uI9$3XWiFHA.576@xxxxxxxxxxxxxxxxxxxxxxx
> Use a GUID. They are guaranteed unique world-wide and make the most sense
> for this type of application.
>
> --
> __________________________________
>
> "boaz" <nospam@xxxxxxxxx> wrote in message
> news:OuD8XyViFHA.1048@xxxxxxxxxxxxxxxxxxxxxxx
>> So, the question is now "How to pick an unique id for your customers?"
>>
>> Why don't you use the entire phone number to be the customer id?
>>
>>
>> "David Richards" <david.richards@xxxxxxxxxxx> wrote in message
>> news:e2FocoQiFHA.1244@xxxxxxxxxxxxxxxxxxxxxxx
>>> Hi, there,
>>>
>>> Thanks for the response.
>>>
>>> This is really the problem, how can I work it so that I can have both
>>> the SQL server, and all copies of the ms access databases generate
>>> unique customer ID's? As they will all be capable of creating new
>>> customer records.
>>>
>>> Thanks
>>> Dave


.

Relevant Pages

  • Re: Replication, GUIDs and PKs
    ... I did a test and guid tables indexes to be 4 times as fragmented as bigint ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... as the subscriber databases are all 2000, and besides it isn't SQL that is ...
    (microsoft.public.sqlserver.replication)
  • Re: GUID default value
    ... > SQL Server and MS Access databases. ... We have default values for the GUID column in Oracle DB ... Autonumber GUID (called a "Replication ID"). ... I don't use Jet DDL since it's not as full-featured as DAO, ...
    (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: GUID on Linux
    ... >> variations. ... starts with the MAC because that is unique to the network card (across ... Ok, at this point it is a Globally Unique IDentifier, or guid. ... objects in databases which are then moved around in other databases. ...
    (comp.os.linux.development.apps)
  • Re: Access 2007 Report
    ... That is create a table of products, and append the unique product names from each of the 5 source databases. ... I suspect the UNION query idea is going to be impractical. ... the "columns" from Customer ID through Zip Code are the SAME for ... and use it as the source for the report. ...
    (microsoft.public.access.reports)