Creating a new MS file

[Husamuddin]

So I've developed a program that collects data from different MS access files and derives new data from them. What I want my program to do is to take all the entered data as well as the new derived data and store them into a brand new ms access file. Is it doable?

 

[jmcilhinney]

There are only two ways to create a new MDB file that I'm aware of:

1. Office Automation.
2. ADOX.

The first option requires Access to be installed. You create an instance of the Access application and basically perform the same steps in code as you would manually in the UI.

The second option doesn't require Access to be installed.

That's the first choice you need to make. Once that's done, you can then check out MSDN for information and ask specific questions here.