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]
