MartyConnelly
martyconnelly at shaw.ca
Thu Mar 25 19:23:36 CST 2004
Just a head's up with these types of GUID keys, they may start to become, a lot more commonly used. I was just reading a paper and methodology developed by IBM Global and the Alberta Government for implemention of privacy legislation across databases. In Canada this would address legislation like Personal Information Protection and Electronic Documents Act, also known by the awkward acronym PIPEDA, or something like HIPPA in the US, there is similar legislation in UK and EU. http://sharp.gov.ab.ca/ppa/documents/AlbertaPrivacyArchitectureOverview.pdf The method is a Privacy Taxonomy which provides a comprehensive scheme to consistently label privacy-relevant objects and actions in an IT environment with an an Identity Key Scheme based on hidden Meaningless But Unique Numbers (MBUNs) to be used over multiple databases in an organization. These MBUN's are going to be long unique keys possibly a GUID. They will map things like a SIN and Drivers license into a MBUN so tables can be accessed or aggregated without giving access to an exact individuals records. Developer wrote: >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. > > > > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid >Sent: Wednesday, March 24, 2004 7:56 AM >To: Access Developers discussion and problem solving >Subject: Re: [AccessD] OT: Migration to SQL Server > > >Anything special you had to do in terms of SQL Server to assist in >managing the resulting databases? for example creating admin users etc > > >Martin > > > >----- Original Message ----- >From: "Mike & Doris Manning" <mikedorism at adelphia.net> >To: "'Access Developers discussion and problem solving'" ><accessd at databaseadvisors.com> >Sent: Wednesday, March 24, 2004 12:27 PM >Subject: RE: [AccessD] OT: Migration to SQL Server > > > > >>Hi Martin, >> >>I migrated four different Access dbs to a single instance of SQL >>Server about a year ago and didn't encounter any problems. >> >>Doris Manning >>Database Administrator >>Hargrove Inc. >>www.hargroveinc.com >> >> >>-----Original Message----- >>From: accessd-bounces at databaseadvisors.com >>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid >>Sent: Tuesday, March 23, 2004 4:58 PM >>To: Access Developers discussion and problem solving >>Subject: [AccessD] OT: Migration to SQL Server >> >> >>Anyone done any work migrating SEVERAL Access dbs to a single instance >> >> > > > >>of SQL Server?? >> >>Particulary interested in any problems this caused etc etc >> >>Maybe a pointer to things to come. I have been asked to look at >>several areas around this subject including building .NET Front Ends >>to migrated dbs. >> >>Martin >> >>-- >>_______________________________________________ >>AccessD mailing list >>AccessD at databaseadvisors.com >>http://databaseadvisors.com/mailman/listinfo/accessd >>Website: http://www.databaseadvisors.com >> >>-- >>_______________________________________________ >>AccessD mailing list >>AccessD at databaseadvisors.com >>http://databaseadvisors.com/mailman/listinfo/accessd >>Website: http://www.databaseadvisors.com >> >> >> > > > -- Marty Connelly Victoria, B.C. Canada