REplicationID Problem

[Michael Kintner]

I am not sure why but when I go to update my record the ReplicationID is
display invalid data format.

The record in the database look slike this:
{000001CF-0000-0000-0000-000000000000}

But when I display the record in a msgbox it shows only the letter I

Any ideas as to the problem? Why doe sit not show the ID?

Thank you in advance for your help,
Mike

 

[David W. Fenton]

I am not sure why but when I go to update my record the
ReplicationID is display invalid data format.

The record in the database look slike this:
{000001CF-0000-0000-0000-000000000000}

But when I display the record in a msgbox it shows only the letter
I

Any ideas as to the problem? Why doe sit not show the ID?

You may need to use the GUIDToString() and StringToGUID() functions
when working with GUIDs. I wouldn't recommend using them for
anything in an Access application, as Access/VBA just don't handle
them well.

There is really no need for GUIDs for your PKs -- random autonumbers
work just fine, unless you're dealing with data sets approaching
some relatively large ratio of the available values. If that was the
case, I'd think a Jet back end was out of serious consideration
anyway.

 

[Michael Kintner]

Excellent, thanks for the info, that worked.

I would have rather not use GUID's, however the application is on its way to
SQL server where GUID is needed to autocreate a new record. Unless you know
of other ways to auto create a new record in SQL with a unique ID number?
The only way I found is using SQL's uniqueidentifier with (newid()). Is
there something better?

Mike