Action queries - playing the Creator

  • Thread starter Thread starter jason
  • Start date Start date
J

jason

Could someone point me to a definative site on how to CREATE

- queries
- tables

....via a QUERY itself?

Somthing like:

CREATE QUERY insertListings
etc etc
 
Hi,


You have to look at SQL statements like

CREATE TABLE tableName ....


and, (with Jet, you need 4.0 and ADO) with

CREATE VIEW queryName ....

and


CREATE PROCEDURE parameterQueryName ...



I suggest "Access 200x Developer's Handbook", Volume I, Chapter 5, at
Sybex.



Hoping it may help,
Vanderghast, Access MVP
 
Many thanks Micheal - I'm hoping our company will allow me to purchase it!

By the way waht is the significance of "Sybex" - is that the publisher?

I will search for this book on Amazon...

- Jason
 
Hi,


Yep. For the authors, the order of their appearance may differ from
version to version, for Access 2000, they are Getz, Litwin, and Gilbert,
for Volume I (the whole book is in two volumes, the first volume being more
"desktop" oriented). It is definitively a reference, and contain much code
easy to reuse (already encapsulated into classes) through cut and paste...
maybe too well done, since you can easily use them without understanding
fully what is involved :-)



Hoping it may help,
Vanderghast, Access MVP.
 
Back
Top