programmatically create mdb

Question

5.00/5 (1 vote)

See more:

Hi!

I have an app which requires mdb files to function.

If I delete data, the size of the mdb file doesn't go down.
I know there are ways to compact mdb files, but I want to create a new
mdb file and also to create a single table with a single colunm and with no index.

Can anyone tell me how to do that?

Posted 31-Jul-10 3:57am

TheMrProgrammer

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Abhinav S · Answer 1 · 2010-07-31T05:50:00

Solution 1

http://www.freevbcode.com/ShowCode.asp?ID=5797[^]

http://msmvps.com/blogs/gaidar/archive/2005/09/13/66282.aspx[^]

Posted 31-Jul-10 5:50am

Abhinav S

Uwe Keim · Answer 2 · 2010-07-31T09:08:00

What I did recently (yesterday to be honest) was:

1. Create an empty MDB file with Access ("empty.mdb").

2. Add the empty MDB file as a resource to my executable. This makes the file accessable as a byte[] array.

3. Whenever I need an empty MDB file, I simple access the byte array and write it as an MDB file to the required destination path on my disk.

4. Then, I can create the tables I want by executing SQL scripts on the new MDB database.

TheMrProgrammer · Answer 3 · 2010-07-31T08:51:00

Solution 2

hey thanks for the reply!

I tried it and it works like a breeze. :)
The only think is that I'll need to provide a separate dll.
Thats a complete no-no for the boss! :(

isn't a portable way to do that?

I have heard that you can combine exe and dlls.
is that true?
how?

Posted 31-Jul-10 8:51am

TheMrProgrammer

Comments

Sandeep Mewara 1-Aug-10 10:22am

Reason for my vote of 1
Not an answer. Either use 'Improve Question' link to update your question OR use 'Add comment' feature to respond to an answer. Don't hit answer button when actually it is not an answer.