Getting all the Tables from a particular MS Access Database

[VeeBee]

Hi everyone,

I like to know how to get all the table names in a particular Database(MS Access) through query commands..

If anybody have some solution, kindly share with me !

Thanks in advance.

[PhillipBrooks · Accepted solution]

Are you using the Database Connectivity Toolkit? If so, use the DB Tools List Tables function from the Utility sub-palette.

[nyc_(is_out_of_here)]

---

@VeeBee wrote:

Hi everyone,

I like to know how to get all the table names in a particular Database(MS Access) through query commands..

If anybody have some solution, kindly share with me !

Thanks in advance.

---

If you don't have the Database Connectivity Toolkit, then you had better brush up on SQL since this is not a LabVIEW problem.

[VeeBee]

Dear Phillip,

Thanks a lot for the vital information.

I was not aware of the palette function & had been searching in the Query commands.

Regards,

Veebee

[VeeBee]

Hi Nyc,

Thanks for the suggestion.

The palette function as mentioned above by Phillip satisfies the requirement, that is found in the database Toolkit.

Just, I wanted to let you also know about this.

Thanks,

Veebee

[nyc_(is_out_of_here)]

---

@VeeBee wrote:

Hi Nyc,

Thanks for the suggestion.

The palette function as mentioned above by Phillip satisfies the requirement, that is found in the database Toolkit.

Just, I wanted to let you also know about this.

Thanks,

Veebee

---

I don't need to know about this.

As I wrote above if you have the Toolkit you should look in there first.

I have no way of knowing whether you have the Toolkit or not.

[Maxilo]

Thanks for the information!!