System.GUID - Microsoft Access / VBA

headware

Is the GUID generated by the .NET System.Guid.New Guid() function
compatible with Access' Replication ID field type?

Dave

Nov 13 '05 #1

Subscribe Reply

10790

Tony Toews

he******@aol.co m (headware) wrote:

Is the GUID generated by the .NET System.Guid.New Guid() function
compatible with Access' Replication ID field type?

Define compatible. What is your objective?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Nov 13 '05 #2

headware

Tony Toews <tt****@teluspl anet.net> wrote in message news:<gr******* *************** **********@4ax. com>...

he******@aol.co m (headware) wrote:
Is the GUID generated by the .NET System.Guid.New Guid() function
compatible with Access' Replication ID field type?

Define compatible. What is your objective?

Tony

Thanks for the feedback. I have a table that contains a GUID field. In
my application I'm filling a DataSet with the user's data and then
using the OleDbDataAdapte r.Update() method to write the data to the
database. The problem is that the GUID field is entered as null when I
do this. My solution was to use the System.GUID.New Guid() method to
manually insert the GUID before calling the Update() method. I'm open
to suggestions if anyone knows of a better solution.

Thanks,
Dave

Nov 13 '05 #3

Tony Toews

he******@aol.co m (headware) wrote:

>Is the GUID generated by the .NET System.Guid.New Guid() function
>compatible with Access' Replication ID field type?

Define compatible. What is your objective?

Tony

Thanks for the feedback. I have a table that contains a GUID field. In
my application I'm filling a DataSet with the user's data and then
using the OleDbDataAdapte r.Update() method to write the data to the
database. The problem is that the GUID field is entered as null when I
do this. My solution was to use the System.GUID.New Guid() method to
manually insert the GUID before calling the Update() method. I'm open
to suggestions if anyone knows of a better solution.

I have no idea as to how well this will work. If you don't get any replies in this
newsgroup in a day or two I'd suggest asking your question in the
microsoft.publi c.access.replic ation newsgroup as the folks who do a lot of work with
replication hang out there.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Nov 13 '05 #4

David W. Fenton

Tony Toews <tt****@teluspl anet.net> wrote in
news:8d******** *************** *********@4ax.c om:

he******@aol.co m (headware) wrote:
>Is the GUID generated by the .NET System.Guid.New Guid()
>function compatible with Access' Replication ID field type?

Define compatible. What is your objective?

Tony

Thanks for the feedback. I have a table that contains a GUID
field. In my application I'm filling a DataSet with the user's
data and then using the OleDbDataAdapte r.Update() method to write
the data to the database. The problem is that the GUID field is
entered as null when I do this. My solution was to use the
System.GUID.N ewGuid() method to manually insert the GUID before
calling the Update() method. I'm open to suggestions if anyone
knows of a better solution.

I have no idea as to how well this will work. If you don't get
any replies in this newsgroup in a day or two I'd suggest asking
your question in the microsoft.publi c.access.replic ation newsgroup
as the folks who do a lot of work with replication hang out there.

Replication really has zilch to do with GUIDs, except that
replication is one of the many applications that use them.

GUIDs are really unusable in an Access application, unless you're
willing to jump through lots and lots of hoops to work with them.
See:

http://www.trigeminal.com/usenet/usenet011.asp?1033

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

Nov 13 '05 #5

dkland

I've been able to use GUIDs successfully in Access up to this point.
The link you listed is broken. Can you supply another link or an
explanation?

Dave

Nov 13 '05 #6

Michael \(michka\) Kaplan [MS]

The link works fine for me:

http://www.trigeminal.com/usenet/usenet011.asp

or

http://www.trigeminal.com/usenet/usenet011.asp?1033
--
MichKa [MS]
NLS Collation/Locale/Keyboard Technical Lead
Globalization Infrastructure, Fonts, and Tools
Microsoft Windows International Division

This posting is provided "AS IS" with
no warranties, and confers no rights.
<dk****@cox.net > wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .

I've been able to use GUIDs successfully in Access up to this point.
The link you listed is broken. Can you supply another link or an
explanation?

Dave

Nov 13 '05 #7

dkland

Well, I'm not using the GUID field as the primary key for the table.
It's only used a one particular semi-replication situation. I only need
to check if a GUID in one database already exists in another database.
I don't need to sort them or display them or do anything tricky.

I really just need to know if the .NET System.GUID.New Guid() returns a
GUID that is compatible with the GUIDs used by Access 2000. It seems to
be working.

Dave

Nov 13 '05 #8

Similar topics

1570

System.NullReferenceException in Interop

by: sergi | last post by:

Hi there, I am getting a System.NullReference exception when calling an unmanaged method CreateClassEnumerator. I am really new to Interop, so that I am having trouble finding out a solution. The code is the following : <code> using System;

C# / C Sharp

3923

System.Type.GUID inter computer consistency (???)

by: Nadav | last post by:

Hi, I am using the System.Type.GUID to identify similar types on different computers, one computer send the GUID through a socket while the other resolve the GUID and identify the type, when working on a single computer everything works fine, BUT, when working on two different computers the GUID extracted from one type is different from the GUID extracted from the same type on the other computer. why is that happening? shouldn't a guid...

C# / C Sharp

3043

marshaling the System::Guid structure

by: Lee Crabtree | last post by:

I've been wrapping an unmanaged class, and everything has gone well. That is...until now. I've hit a wall while trying to marshal the System::Guid type down into the unmanaged GUID structure that the unmanaged class asks for. For some reason, none of my attempts to date have met with success. Maybe someone else has an idea how this works? Lee

.NET Framework

6340

system.byte[] and system.guid compare

by: rcolby | last post by:

Evening, Wondering if someone can point me in the right direction, on how I would compare a system.guid with a system.byte. system.guid (pulled from sql server table with a data type of uniqueidentifier, originally taken from objectGUID from active directory domain)

Visual Basic .NET

10289

File system GUID for a file

by: Tarren | last post by:

Hi: I need to get the unique GUID for a file, so I am using API calls through System.InteropServices I am using BY_HANDLE_FILE_INFORMATION and

C# / C Sharp

6501

System.Guid

by: Michael Primeaux | last post by:

I have a simple .NET 2.0 web service created with VS.NET 2005 with a single web method with the following signature: void HelloWorld(Guid parameter1); When calling this method I receive the following error: System.IndexOutOfRangeException: Index was outside the bounds of the array. at System.Web.Services.Protocols.HttpServerType..ctor(Type type) at System.Web.Services.Protocols.HttpServerProtocol.Initialize()

.NET Framework

2018

Casting to System.Guid

by: Jeff | last post by:

ASP.NET 2.0 In the code below, the reader has a column named "Id". The MsgInfo class needs that value sent into its constructor. But MsgInfo need it as a System.Guid datatype. How do I convert this "Id" value to System.Guid datatype?? protected virtual MsgInfo ReadMessage(IDataReader reader) { return new MsgInfo(System.Guid(reader) <.---- this code crashes

ASP.NET

5725

Problem with System.Guid and duplicate key

by: Jeff | last post by:

ASP.NET 2.0 This problem occur using the basic version of SQL Server 2005 which get installed when installing Visual Studio 2005! I have inserted a record in the Test table. But when I try to insert a second record I get this error: {"Violation of PRIMARY KEY constraint 'PK_Test'. Cannot insert duplicate key in object 'dbo.Test'.

ASP.NET

12029

Covert string to System.Guid, how??

by: Jeff | last post by:

ASP.NET 2.0 I'm wondering how to convert a string into a System.Guid! I have this code where I want to use the convert: Message.DeleteMessage(hidden.Value);. Here DeleteMessage wants an argument of type System.Guid, but the hidden.Value (HiddenField) has stored it as a string. I need to convert the value of hidden.Value to a System.Guid for this to compile, but how??

ASP.NET

9298

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10072

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

7286

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6562

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5172

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5329

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3829

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3399

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2698

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General