create new database programmatically

[id]

I am trying to create a new MS Access database to log some results to during a labview program using the datab ase connectivity toolkit.  The examples show how to link and create a new table in an existing database file, but I want to create a new database and tehn insert a new table in it for my logged results.  Any ideas??

[Dennis_Knutson]

Creating a database is usually a one time operation. Why would you want to do this?

[id]

All I need to do is log to an mdb table for subsequent SQL operations in my labview program. 

[nyc_(is_out_of_here)]

---

@id wrote:

All I need to do is log to an mdb table for subsequent SQL operations in my labview program. 

---

And this answer does not answer the question why you need to do this in LabVIEW when creating a database is a one-time only event.

Usually best to do manually since you may want to set permissions and passwords, etc.

Also, you will need to create tables in the Access database; otherwise, it is pretty useless.

[id]

It isnt a one time event for me.  I have to sanitize/wipe clean the temp folder that it is in after each test run.

[aputman · Accepted solution]

Do you have Access installed where you can create a blank MDB file?  If so, you could create one and store it as a template in your program folder.  Copy and paste it when you run your routine and use the Create Table VI in the toolkit to create tables to write to.  It is possible to create tables during an INSERT but you can't control properties of the fields.  The OP in this thread is doing that very thing. (http://forums.ni.com/t5/LabVIEW/Database-connectivity-toolkit/m-p/3046359#M868188)

[mikeporter]

Wait, what do you mean by the "temp directory that it is in"? What is a database doing located in a temporary directory? A database is supposed to be permanent storage for data. You need to basically rethink what you are doing.

Mike...