SQLDAOLoader.mdb (advanced) |
Post Reply |
Author | |
Roger Carlson
Microsoft MVP Joined: 20 Feb 2008 Status: Offline Points: 261 |
Post Options
Thanks(0)
Posted: 22 Jul 2008 at 10:28pm |
Please consider donating $1 per sample downloaded, find out why here.
SQLDAOLoader.mdb This sample shows how to modify the structure of a Back-End database using SQL DDL (data definition language) statements and DAO code. This sample does much the same as "SQLLoader.mdb", but does not require text files to hold the SQL. Further, it utilizes DAO to accomplish some tasks that Access SQL does not allow, like Default Values (and other field attributes), creating Autonumber and Hyperlink fields, and modifying Field Names.
All of the code is stored in modules this sample and behind this form. The changes are stored in the UpdateSteps table also in this database. Each record in UpdateSteps has the name of a subroutine and the necessary arguments. They are as follows: RunSQLDDL: a SQL String Notes: Access 97 (89 KB): uploads/5/SQLDAOLoader97.zip Access 2000 DAO (98 KB): uploads/5/SQLDAOLoader2K.zip |
|
|
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |