How can I use a Replication ID as text in Microsoft Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I'm using Microsoft Access 2003 as front end to a SQL Server database.
The SQL Server database has uniqueidentifiers...
Displaying the uniqueidentifiers is not a problem when I simply display it
(drag the field on a form for example). But when I need to use the value of a
uniqueidentifier dynamically (to create a new SQL query for example), the
uniqueidentifier is never returened correctly (either plenty of squares,
either plenty of question marks).
Is there a workaround to this? (CStr doesn't work)
Thanks!
 
Hi, there are two functions to convert dB guids to useable format in VBA:

GUIDFromString
StringFromGUID

Hope this helps, Graeme
 
Back
Top