title: Is there an Access equivalent of the SQL Server NewId() function?
body: <p>I have written SQL statements (stored in a text document) that load data into a SQL Server database.  These statements need to be repeated daily.  Some of the statements use the <code>NewId()</code> function to populate a keyed field in the database, and this works fine.</p>
  <p>While I'm in the process of writing an application to replicate these statements, I want to use Access queries and macros instead of copying and pasting queries into SQL Server, thus saving me time on a daily basis.  All is working fine but I can't find any function that will replace the SQL Server <code>NewId()</code> function.  Does one exist or is there a work around?</p>
  <p>I'm using SQL Server 2005 and Access 2007.</p>