Access DDL/DMO??

#1 September 6th, 2005, 12:31 PM

Hi all,

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

Thanks,
Ivan

#2 September 6th, 2005, 03:04 PM

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/de.../acfundsql.asp

--
Brendan Reynolds (MVP)

"Ivan Debono" wrote in message
...
Hi all,

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

Thanks,
Ivan

#3 September 6th, 2005, 03:29 PM

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

Ivan

"Brendan Reynolds" schrieb im
Newsbeitrag ...
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/de.../acfundsql.asp

--
Brendan Reynolds (MVP)

"Ivan Debono" wrote in message
...
Hi all,

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

Thanks,
Ivan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Ambiguous Name Error	pm	Using Forms	10	June 5th, 2005 09:19 PM
2002 vs 2003	Patrick Stubbin	General Discussion	2	May 17th, 2005 07:27 AM
The "Right" web hosting for data access pages??	Ron Ehrlich	General Discussion	9	May 6th, 2005 05:49 AM
Book recommendations, please	Top Spin	New Users	2	March 1st, 2005 12:43 AM
is Access 2003 any better than XP?	Gorb	General Discussion	4	November 11th, 2004 09:44 PM