How to get the name of selected table in MS access

[Dipsy]

I am using MS access database.

If I select any particular table in access DB, is it possible to get that table name in Labview?

In short, I want to display the name of table which is selected in Access on front panel.

Also, same way I want to display the name of field in table, selected in DB.

Is it practically possible??

Thanks for ur help in advance

[Yi Y]

Hi Dev,
Are you using the Dabase Connectivity Toolset to talk to your Access DB? How are you "selecting" the table? If you are just selecting the table in Access, there's no way for LabVIEW to know what you are doing in Access.  If you write your own query, you can use the DB Tools Execute Query VI to execute any SQL query, then you can parse the results, be it a table name or anything else.

Yi Y.
Applications Engineer
National Instruments
http://www.ni.com/support

[Dipsy]

Hey,

Thanks for the reply.

i am using Activex to communicate to MS access DB.

Now, i am able to get the table name selected in DB, but if i select any particular field in the table,

is it possible to get the fild name in LV using activex?

[Yi Y]

Hi Dev,
How are you selecting a field in the table without knowing its name?  If I'm understanding you correctly, are you selecting the field in Access and trying to read that selected field in LabVIEW? I'm not sure what API you are working with, but it depends on what the API exposes as to what operation you can do, so it's hard for me to say whether you can do that or exactly how to do it.  I would recommend doing more research on the specific API you are working with to find out that information.

Yi Y.
Applications Engineer
National Instruments
http://www.ni.com/support