Pb how to obtain access database under the name of the table

CodePudding user response:

If it is to use DATAWINDOW, assuming the DATAWINDOW control called DW_1, table named ls_tablename, then:

Ls_tablename=DW_1. The Describe (" DataWindow. Table. UpdateTable ")

CodePudding user response:

- lists all the users table

SELECT *
The FROM MSysObjects
WHERE the Flags=0 AND Type=1

CodePudding user response:

You can use AdoX.