Access DDL/DMO??

Ivan Debono · Sep 6, 2005

Hi all,

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

Thanks,
Ivan

Brendan Reynolds · Sep 6, 2005

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 · Sep 6, 2005

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

Ivan