RE: [MS_AccessPros] Ms access using SQL server

 

Hi Terence

 

That's a very old version.  I suggest you download and try either the ODBC Driver 11

(https://msdn.microsoft.com/en-us/library/jj730314%28v=sql.110%29.aspx )

or the Native Client 11 (https://msdn.microsoft.com/en-us/sqlserver/aa937733.aspx).

 

-- Graham

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, 18 May 2015 16:48
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Ms access using SQL server

 

 

Graham,

 

additional info

When i use my windows control panel, admin tools and display the connection this is what i see:

 

Microsoft SQL Server ODBC Driver Version 06.01.7601

 

Data Source Name: PHQCDB

Data Source Description: PHQCDB DB Access

Server: PHQCDB

Database: PHQCDB

Language: (Default)

Translate Character Data: Yes

Log Long Running Queries: No

Log Driver Statistics: No

Use Regional Settings: No

Prepared Statements Option: Drop temporary procedures on disconnect

Use Failover Server: No

Use ANSI Quoted Identifiers: Yes

Use ANSI Null, Paddings and Warnings: Yes

Data Encryption: No

 

 

Terence

Any help is greatly appreciated.

 

 

__._,_.___

---

Posted by: "Graham Mandeno" <graham@mandeno.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (15)

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___