Thanks for your reply. In looking at those two System tables and experimenting with a few new queries, I could probably guess at many of the fields and rows that I would need, but some fields are storing LOBs and that just raises a red flag for me.
I'm dealing with CLOBs in Oracle at work and I really don't need to learn the Access way of the comparable binary objects just for my simple little application. I'll do it the old-fashioned...
DonnaL
Last Activity: Jul 18 '07, 06:32 AM
Joined: Jul 16 '07
Location: Southern California
-
-
Is there a way to insert Queries programmatically?
I'm using Access 2000, but this question likely pertains to any version of Access. Simply put, is there a programmatic way of inserting a new Query in whatever master system table stores these (maybe QueryDefs?), so I wouldn't have to use the IDE and open Access to do it?
Here's more information if that helps: I can open Access itself and create a Query. I can save it and name it something meaningful. I can then execute that query...
No activity results to display
Leave a comment: