Duplicate a table in VB Command, Creat exe From a project

[Jibanananda Goswami]

I have created an access project. I want to sell it in CD as exe file. I also want to be sure that no one can copy or modify the project.
I want to Creat a copy of an existing table by clicing a command in form, So that the original table does not altered.

[missinglinq]

You cannot make an .exe file from an Access database! With the purchase of (fairly costly) additional software from Micro$oft, you can make a version that runs on a computer that does not have Access installed. The exact name of this additional software varies, depending on which version of Access you have. But if your main concern is preventing someone from stealing the work you've done on your database, what you can do is create an .MDE version of it. An .MDE version of a database cannot be changed, altered or modified in any way, by the end user or by you! And hence the next paragraph!

First off, make a backup copy of your original database! Put it someplace safe! Under your mattress, in your hip pocket, next to your dog's food bowl! If you lose your original .MDB file, you cannot make changes to your database!

Next, set up everything in your database exactly as you want it to appear to the end user. Go into the VBE (the code window behind one of your forms) and goto Debug -- Compile<YourDatabaseName> and click. Access will show you any mistakes you have so that you can correct them.

Once this is done goto Tools -- Database Utilities -- Make MDE file

This is the file you eill use for distribution. It cannot be altered in any way. Whatever capabilities the MDB file had when you made the MDE file will be the capabilities of the MDE.

Let us know if you have any problems/questions.

Good Luck!