how to save the current access database as a new file with a specified name

[lksusier]

what I am trying to do is after writing data to a public access file, save it as a new access file,

clear the public access file and write new data in it.

repeat the above process when requested by the operator.

which database function should I　use to execute this "save as " action?

thank you...

[LVbum42]

I'm not sure what DB tools you are using in LabVIEW however I was able to locate the following function that seems to accomplish what you asked about.

DB Tools Save Recordset To File VI: http://zone.ni.com/reference/en-XX/help/370016C-01/lvdatabase/db_tools_save_recordset_to_file/

As far as database applications go there are several examples included in LabVIEW some of which include SQL functions as well.

Regards,

Isaac S.

[lksusier]

Thanks for your reply, I hope to save the file as .mdb file (access database file)

I simply could not find the module that could possibly do that.

[dkfire · Accepted solution]

Why not just use the normal file operation functions ?

There you can copy your Access file, it just a file. 

You can find the copy function in the palette : Programming -> File I/O -> Adv File Funcs -> Copy

[nyc_(is_out_of_here)]

---

@lksusier wrote:

Thanks for your reply, I hope to save the file as .mdb file (access database file)

I simply could not find the module that could possibly do that.

---

Why are you creating a new access database for each new iteration???

This defeats the purpose of a database which is used generally used to store multiple sets of data.

[lksusier]

I figured this out yesterday. I was just stuck with the Database operations and completely forget the most basic functions. 😞

[lksusier]

Thanks for your reply.

That was a request from a databse programmer, I was told the file created will make it convenient for him to import data to another database.

anyway, just want to get it done so I can move on to more critical tasks.