Getting Meta Data only from ADO Data Control at Design time 
Author Message
 Getting Meta Data only from ADO Data Control at Design time

I have an ADO Data Control on which I have specified a Connection &
RecordSource (usually a SQL statement and/or strored query). At design time,
all I need is the meta-data describing the RecordSet. However, even at
design time,  the ADO Data Control executes the query and populates a

My problem is that sometimes the query take a long time to execute -- I have
to wait even though I do not want or need the data. This is especially a
problem in final testing against production size databases.

Is there any (automatic) way to tell the ADO Data Control to return only
meta-data (or empty RecordSets) in design mode, but fully poppulate then in
Run mode (both IDE and Compiled EXE). (Logically similar to the way that
"Debug.Assert" statement executes only in the IDE and not in Compiled code.)



Sun, 06 Mar 2005 05:55:40 GMT  
 Getting Meta Data only from ADO Data Control at Design time
Make sure your query it executes is simply "Select * from Table where 1=0"

This will return an empty recordset with all of the metadata.

Scot Rose, MCSD
Microsoft Visual Basic Developer Support

Want to know more? Check out the MSDN at or the Microsoft Knowledge Base at

This posting is provided AS IS, with no warranties, and confers no rights.

Tue, 08 Mar 2005 21:27:54 GMT  
 [ 2 post ] 

 Relevant Pages 

1. ADO Data Control - Design Time/Run Time database locations

2. ADO data control Design -vs- Run Time

3. getting run-time behavior of a contained control in a user control at design time

4. Read Diffrernt Data type of Meta Data from jpeg

5. 3.0 Design time, data control, secure database

6. Read Fields Name from a data environment in a User Control at design time

7. Adding controls to data report in design-time

8. ADO data control 6.0 and ADO data object 2.1 conflict

9. Using ADO Data Control on User Control as Data Source

10. Meta data withthe internet transfer control?

11. Create User Control as Data Source Using ADO Data Control

12. Help - Simply Getting Data from Extrenal Data Files (not from Access Data Base)


Powered by phpBB® Forum Software