Create tables : lookup feature

  • Thread starter Thread starter Peter Warnez
  • Start date Start date
P

Peter Warnez

All,

I have an .adp project in A2003 on sql 2000.
When creating a new tabel/view with the user interface of access it's
possible to "connect" a row with a lookup table (via properties pane of the
view/table).

I want to create a new table and setup the lookup-feature by code (VBA) with
ADO/ADOX. I thought I had to do it by setting the specific property
(rowsource, table, boundcolumn,....), but I can't find how to do it.

If I create a table with the user interface of Access and afterwards I check
the individual properties of the table and rows (with VBA) I can't see which
property I have to create and how to do it.

Any suggestions?

Tnx,

Peter
 
There are probably stored as extended properties: With the Enterprise
Manager, open the contextual menu for the table, then select All
Tasks ->Generate SQL Script. On the Formating tab, select "Include extended
properties" then generate the preview script. From there, you will the
extended properties.

On the BOL, you will find the relevant information for creating and
retrieving extended properties. You won't find there the specific
information as used by Access but it's probably easy to discover by looking
at what Access is writing in these extended properties.

However, in my opinion, you should use Forms instead of grids: going the
table/view ways will only be an exercice in frustration.

S. L.
 
Thanks a lot !!

Sylvain Lafontaine said:
There are probably stored as extended properties: With the Enterprise
Manager, open the contextual menu for the table, then select All
Tasks ->Generate SQL Script. On the Formating tab, select "Include extended
properties" then generate the preview script. From there, you will the
extended properties.

On the BOL, you will find the relevant information for creating and
retrieving extended properties. You won't find there the specific
information as used by Access but it's probably easy to discover by looking
at what Access is writing in these extended properties.

However, in my opinion, you should use Forms instead of grids: going the
table/view ways will only be an exercice in frustration.

S. L.
Click to expand...
 
Back
Top