[dba-SQLServer] dynamically create MS Access database via DTSpackage

You can also use  ADOX VB code to create fields and indexes in tables.
Sample code here
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html/deovrcreatingmodifyingaccesstables.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html/deovrcreatingmodifyingindexes.asp?frame=true

You can set keys and relationships  with MS SQL though. (lower case user 
defined)
   CREATE TABLE Table1 (Id COUNTER CONSTRAINT PrimaryKey PRIMARY KEY, 
MyText TEXT (10))
   CREATE TABLE Table2 (Id LONG, MyText TEXT)
   ALTER TABLE Table2 ADD CONSTRAINT Relation1 FOREIGN KEY ([Id])   
REFERENCES Table1 ([Id])

Creating and Modifying Stored Queries via ADOX with Caveats

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html/deovrcreatingmodifyingstoredqueries.asp?frame=true


Mike & Doris Manning wrote:

>SQLDTS.com is my favorite link when I need help of this time.  Here is a
>link that shows you how to create an Access database from scratch using DTS
>http://www.sqldts.com/default.aspx?288
>
>I also highly recommend Microsoft SQL Server 2000 DTS (ISBN 0672320118)
>
>Doris Manning
>Database Administrator
>Hargrove Inc.
>www.hargroveinc.com
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada