Results 1 to 3 of 3

How to set SQL Database QUOTED_iDENTIFIER Property from Access

  1. #1
    EddieN1 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2011
    Posts
    244

    How to set SQL Database QUOTED_iDENTIFIER Property from Access

    Can anyone tell my how to set the QUOTED_IDENTIFIER property for a SQL Server 2008 R2 to OFF from MS Access using VBA code. I'm using ADODB to pass SQL string to SQL Server. Thanks, Eddie

  2. #2
    AccessMSSQL is offline Expert
    Windows XP Access 2010 64bit
    Join Date
    Apr 2012
    Location
    Los Angeles
    Posts
    75

  3. #3
    EddieN1 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2011
    Posts
    244
    Thanks, that's what I ended up doing. I didn't want to post a solution till I was sure it worked. However, if the database is SQL Server I prepend "SET QUOTED_IDENTIFIER OFF " to my SQL statement I generate when I open the recordset. Thanks for your help. Eddie

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Moveable Property in Access 2007
    By Desverger in forum Database Design
    Replies: 7
    Last Post: 08-15-2012, 12:41 AM
  2. Replies: 20
    Last Post: 08-08-2011, 12:34 PM
  3. Replies: 3
    Last Post: 05-15-2011, 09:52 PM
  4. Migration from Access 2003 database to Access 2007 database.
    By cyclus2 in forum Import/Export Data
    Replies: 1
    Last Post: 09-10-2010, 10:43 AM
  5. Access 2003, sort order property of a form
    By Rick West in forum Forms
    Replies: 11
    Last Post: 09-17-2009, 07:28 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums