how to copy all mdb tables to new mdb file

Sunil Bansode

Rate me:

0.00/5 (No votes)

9 Oct 2012CPOL

3.2K

Respected sir, I have created Data.mdb for my windows application in which i have many tables.now i want to create same but new and blank database having same tables for every year without old data at runtimehow to do this..Please help me..Thank you..

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

1. how to copy all mdb tables to new mdb file

9 Oct 2012Zubair Alie

Inside MS SQL Management Studio 1- Right Click your Database2- Tasks - > Generate Script3- follow the steps appeared to you in pop-up (choose to select All, it will select all of your tables, views, procedures etc)4- choose to generate file at any of your specified location5- open...

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Sunil Bansode

Software Developer (Senior)

India

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

how to copy all mdb tables to new mdb file

Alternatives

License

Comments and Discussions