|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 29th, 2005, 04:37 PM
|
|||
|
|||
access and sql server via odbc
When writing a pass-thru query in Microsoft Access to access an sql server
via an odbc system dsn, I can write a query like: select * from MyTable However, when doing: select * from MyView I get an error. Is it not possible to query a view in this manner or is the syntax different for views? 
|
|
#2
September 29th, 2005, 05:08 PM
|
|||
|
|||
|
On Thu, 29 Sep 2005 23:37:33 +0800, arch wrote:
When writing a pass-thru query in Microsoft Access to access an sql server via an odbc system dsn, I can write a query like: select * from MyTable However, when doing: select * from MyView I get an error. Is it not possible to query a view in this manner or is the syntax different for views? The syntax is right. What error do you get?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Upsizing design considerations | philr | New Users | 9 | September 12th, 2005 06:51 AM |
| ACCESS / SQL SERVER | AYUDA DE ACCESS | General Discussion | 0 | July 9th, 2005 02:16 AM |
| Code Not Working | DS | New Users | 11 | May 9th, 2005 10:55 PM |
| Unable to insert record to Access via SQL from an ASP page | Norman Yuan | General Discussion | 1 | February 2nd, 2005 08:23 PM |
| ODBC: Access 97 -> SQL Server 2000 | Michael Schwab | General Discussion | 0 | November 17th, 2004 01:04 PM |
Linear Mode
