Roger's Access Library Homepage
Forum Home Forum Home > Roger's Access Library > Roger's Download Samples
  New Posts New Posts RSS Feed - RecreateTableInSQL.mdb (advanced)
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Please consider donating $1 per sample downloaded, (find out why here)

RecreateTableInSQL.mdb (advanced)

 Post Reply Post Reply
Roger Carlson View Drop Down
Microsoft MVP
Microsoft MVP

Joined: 20 Feb 2008
Status: Offline
Points: 261
Post Options Post Options   Thanks (0) Thanks(0)   Quote Roger Carlson Quote  Post ReplyReply Direct Link To This Post Topic: RecreateTableInSQL.mdb (advanced)
    Posted: 28 Jul 2008 at 10:21pm
Please consider donating $1 per sample downloaded, find out why here.
This sample will read the table structure of the table selected in the listbox and programmatically build a series SQL statements to recreate the table and all indexes. The SQL Statements are saved in a script file with a .sql extension. Files can be created in Access SQL or T-SQL (SQL Sever).
Access 2000 DAO (34 KB):
Consider donating $1 per sample downloaded, find out why here.<
Back to Top
Sponsored Links

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.