Access DDL/DMO??

[Ivan Debono]

Hi all,

Is it possible to create foreign keys, indexes, drop & create queries using
SQL with an Access 2000 database?

Thanks,
Ivan

 

[Brendan Reynolds]

Check out the KB article at the following URL. This is the first of three
articles (fundamental, intermediate, and advanced). There are links to the
other two articles from this one.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acfundsql.asp

 

[Ivan Debono]

Thanks. Looks like it will work but only throught Jet OLE DB and ADO...
which is basically what I need!!

Ivan