linking all fields in linked table? 
Author Message
 linking all fields in linked table?

Is there a way to link to an external (Access) table and add all the fields
in the external table without knowing ahead of time what fields are in the
table?  Much like the Access front-end does, but thru code.

I'm trying to write a generic table-linker procedure.

Thanks for your suggestions.



Sun, 21 Oct 2001 03:00:00 GMT  
 linking all fields in linked table?

Quote:

> Is there a way to link to an external (Access) table and add all the fields
> in the external table without knowing ahead of time what fields are in the
> table?  Much like the Access front-end does, but thru code.

> I'm trying to write a generic table-linker procedure.

> Thanks for your suggestions.

If you are just trying to produce a link to an external table, you do not need
to know what fields are contained therein.

--
-------------------------
| gHaD (Aaron Robinson) |
|MJM-PC Solutions, Inc. |
|      Chicago, IL      |
-------------------------



Sun, 21 Oct 2001 03:00:00 GMT  
 linking all fields in linked table?
The answer is the .sourceTable property.
It apparently catches all the fields.


Sun, 21 Oct 2001 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Changing the linked table path without the linked table manager

2. Linked tables - changing the link

3. Changing Linked Table link?

4. Visual Linking: Can link by 2 fields?

5. To link procedure and table in visual linking...

6. Visual Linking: Can link by 2 fields?

7. Appending a field to a linked table

8. Adding a new Field to a Linked (or Imported) Table

9. Adding a Field to a Linked table

10. Adding a field to a linked table

11. Add field to linked table

12. Increase field size in linked table

 

 
Powered by phpBB® Forum Software