Sql database with Access frontend and GUID

Discussion in 'Databases' started by Connie Prince, Dec 14, 2015.

  1. I have an access frontend to a sql 2012 database. I am trying to fill a field with newid() or pull an automated GUID to save to the database but access doesn't like newid() for the field value. Any ideas how to create a new guid for a field and save in sql database. Thanks for any suggestions?
     
  2. Try this command: "create table hede(Id Guid)". This is the starting point.
     

Share This Page