Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Doctor Doom
Starting Member
12 Posts |
 Posted - 2004-03-23 : 11:04:39
|
| Hy there,I hope my question isn't already asked by someone. If so, I'm sorry for that; the forum is too big to look it up!My problem:In Access there are tables and queries. It is possible to make a connection to these tables and make SQL-statements (by use of for example Visual Basic, Java, C++,...).My question:Is it also possible to make connection to already existing queries?This will make my project so more simple than creating a query by more SQL-statements.Thanks in advance |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2004-03-23 : 11:14:04
|
| Worth a try !select * from <queryname>- Sekar |
 |
|
|
Doctor Doom
Starting Member
12 Posts |
Posted - 2004-03-23 : 11:25:49
|
| Never taught it would be that easy.I'm gonna give it a try.Thanks! |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-03-23 : 13:30:28
|
| Maybe I'm being too technical here, but you don't make a connection to a query or a table. You make a connection to a database. From there you can issue your SELECT statements on tables or queries just as if you were in the Access query builder.--------------------------------------------------------------Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url] |
|
|
|
|
|
|
how to connect to queries?