Beginning Visual Basic 2005 Databases.
Try It Out on page 102
I keep getting error on the following line:

objCommand.Parameters.Add("@ProjectID", OleDbType.Guid, 16).Value = _
            New Guid(txtProjectID.Text)

The error is:
FormatException was unhandled
Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).

I thought I had mistyped the code, but I get the same error with the downloaded code.

Note: I am using Visual Basic 2005 Express Edition.

Thanks for any help.

Is the ProjectID field in your Access database defined as a Number and set to a Field Size of Replication ID? If this is the case then you'll need to look up in the online help for Visual Studio the constructor for the GUID structure. I do not have the Express edition installed nor do I have access to a test machine that I can install it on.

Thearon

Yes, the ProjectID is defined as Number with filed size set to Replication ID.

I've been thru the VB online help already, but at this point in learning, nothing jumps out at me as to how to correct this error.

I figured out what I was doing wrong. Not sure what I was thinking but I was clicking on the Parameter Query button before entering the GUID (duh ...). And since the exception for an invalid GUID (blank) was unhandled I got the error shown above.

I'm glad the problem is resolved.

Thearon