how to poke a GUID in to an attached SQL table

[Tony Epton]

If this question belongs in a different ng could someone please gently
point me to it.

I've figured out how to hack in to the SQL MSDE backend of the
Business Contacts Manager in Outlook 2003 and I've partly reversed
engineered what needs to be written in to all the tables to achieve an
Account or Business contact record.
(Yes I know they will totally change everything in the next release of
BCM)

A small stumbling block is that "dbo.ContactMainTable" really needs a
GUID value poked in to field EntryGUID

I've figured out two ways to do this so far:
1) use a stored procedure in the SQL backend and use the SQL function
"NewId()"
2) set up a table with very similar structure in Access where
EntryGUID is autonumber replication , load all the values I need for
the record in to this access table and then append it to the SQL
table.

I would really like another method like:

rs!EntryGUID = <something> using DAO or ADO code

Any suggestions please ?

Many thanks in advance
Tony Epton

ps - various googling hints at there being an outlook.bcm newsgroup
but I have never found it - anyone else found it ?

 

[Brendan Reynolds]

The first and sixth articles in the list at the following URL look like they
may be of interest ...

http://search.microsoft.com/search/results.aspx?qu=VB+generate+guid

 

[Tony Epton]

Many thanks

Works a treat

Tony