Session specific GUID

  • Thread starter Thread starter Mark Jackson
  • Start date Start date
M

Mark Jackson

I have a hidden table that is storing information that users type into
a form. There could potentially be several users with copies of the
same form open. In SQL server I used the uniqueidentifier data type to
get a unique GUID that was stored in the table that identified each
user's data so they didn't step on each other. Is there anything like
that in Access? The only references to GUID I have found have been to
the GUID's of various COM objects.

Thx

Mark Jackson
 
Mark,

You have a couple of choices.

1. Use the form's handle; this is the simplest. It's not a GUID, but it's
likely to be unique.
Me.hWnd

2. Create a GUID. The following is just one way; there are many:
Public Function CreateGUID() As String
Dim TypeLib As Object
Dim sGUID As String

'Create the appropriate object
'Note that Scriptlet.TypeLib should be installed
'on any machine running IIS
Set TypeLib = CreateObject("Scriptlet.TypeLib")

'Grab a GUID
sGUID = TypeLib.guid

'Extract the useful portion of the GUID
CreateGUID = Mid(sGUID, 2, Len(sGUID) - 4)

'Release the object
Set TypeLib = Nothing
End Function

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia
 
Mark Jackson said:
I have a hidden table that is storing information that users type into
a form. There could potentially be several users with copies of the
same form open. In SQL server I used the uniqueidentifier data type to
get a unique GUID that was stored in the table that identified each
user's data so they didn't step on each other. Is there anything like
that in Access? The only references to GUID I have found have been to
the GUID's of various COM objects.
Click to expand...


This will work in Access as well:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wss/wss/_hosting_getguid.asp
 
Back
Top