or setup a table in ms sql server to create say 5000 rows, each of which is a UUID
export those to a table in the access db and then take one out for every record and insert it as the primary key.... > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > Sent: 03 December 2002 15:56 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] Microsoft Access GUID? > > > > Could use CreateUUID() and insert that into a column other than your > autonumbered ID field. > > > Duncan Cumming > IT Manager > > http://www.alienationdesign.co.uk > mailto:[EMAIL PROTECTED] > Tel: 0141 575 9700 > Fax: 0141 575 9600 > > Creative solutions in a technical world > > ---------------------------------------------------------------------- > Get your domain names online from: > http://www.alienationdomains.co.uk > Reseller options available! > ---------------------------------------------------------------------- > ---------------------------------------------------------------------- > > > > > "Martin Gill" > > <Martin.Gill@un To: > <[EMAIL PROTECTED]> > itech.net> cc: > > Subject: [ > cf-dev ] Microsoft Access GUID? > 12/03/02 03:54 > > PM > > Please respond > > to dev > > > > > > > > > Hi > > Does any one know if Microsoft Access has the equicolent of the SQL > server GUID. Im designing an email postcard app where the person > receiving the card gets a link to the card and has to click > on it to see > the card. The URL link will need to contain an ID or equivolent. If it > is a sequential ID as generated by a typical autonumber field then > people have the opportunity to alter the ID and view a card > intended for > someone else. Unfortunately, upgrading to SQL Server is not an option > for the client at this stage. > > Martin L. Gill, MSc - Head Programmer > > For & on Behalf of UniTech > (The Universal Information Technology Group Ltd) > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > URL: http://www.unitech.net > Email: [EMAIL PROTECTED] > > UniTech House, 25 Bernard Street, Leith, Edinburgh, EH6 6SH > Tel: +(44) 0131 472 5555 > DDI: +(44) 0131 472 5560 > Fax: +(44) 0131 472 5556 > > > > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
