I have some problems here. How to SELECT & OPEN tables created in MS Access using VB? Is it possible to be done? I've created 3 tables in MS Access, and now I wish to create a VB application to SELECT and OPEN the certain tables through VB application to retrieve the information. How to link/connect both together?
Everytime if i create a new table in same Ms Access file, the VB program will auto detect and add to the new list. Which meant VB has to open the Access file, retrieve all the available tables in the file and shown in VB application. Users can select which tables to open in VB environment.
Can anyone provide me some coding on how to implement this?
I'm also a bit doubt whether this is a logic question, wish experts here could assist me in this. Many thanks!