Very Computer

by **Brad** » Thu, 19 Jul 2001 02:59:22

I have serveral Access 2000 databases that I'm importing
into SQL 7 with one problem. I extensively use the schema
object in asp which uses the description column in access
2000 i.e. field_name data_type description. I have not
found how SQL 7 handles or if it does the "description"
from Access. I noticed in SQL 7 that you can import the
metadata and see the descriptions associated with Access
field names but I've yet to figure out on how to import
them into SQL7 if it supports it.

Please advise.

by **Gabriele Pont** » Thu, 19 Jul 2001 03:39:12

I don't think you can import the description from Access. Since you want
only to read schema object, I would still use the Access database in the ASP
pages. I don't see any big impact on performance.

Gabriele

Quote:> I have serveral Access 2000 databases that I'm importing
> into SQL 7 with one problem. I extensively use the schema
> object in asp which uses the description column in access
> 2000 i.e. field_name data_type description. I have not
> found how SQL 7 handles or if it does the "description"
> from Access. I noticed in SQL 7 that you can import the
> metadata and see the descriptions associated with Access
> field names but I've yet to figure out on how to import
> them into SQL7 if it supports it.

> Please advise.

Very Computer

Access 2000 ADOX schema/ Table Field Descriptions

Access 2000 ADOX schema/ Table Field Descriptions

Access 2000 ADOX schema/ Table Field Descriptions