[AccessD] OT: Migration to SQL Server - sort of

They're something more than strings, Gustav.  I've worked with them in
Access and frankly, it wasn't worth the effort, so I abandoned them.  Of
course Access can deal with GUIDs, since that is what replication uses.
It just ain't pretty and requires a LOT of coding and work.  You can't
do simple comparisons on them, and they're generally painful.

Charlotte Foust

-----Original Message-----
From: Gustav Brock [mailto:gustav at cactus.dk] 
Sent: Wednesday, March 24, 2004 8:56 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] OT: Migration to SQL Server - sort of


Hi Developer

How's that? Aren't GUIDs, at the table level, nothing more than strings?

/gustav


> Not exactly migration, but biggest issue I've had lately with Access 
> FE's to SQL 2k is that Access can't deal with GUID's.  You *must* make

> all the queries that join on these types of fields  into views because

> Access can't relaibly make these joins.

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com