We help IT Professionals succeed at work.

display the access tables in the database in a list box

212 Views
Last Modified: 2012-06-27
I have a visual basic 6.0 which displays "DriveListBox" when selected- it displays a "DirListBox" when a Dir is select, FileListBox" displays Access databases. How do I display the tables in the database
Comment
Watch Question

Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
 here is the code that I used for the set
 Set db = OpenDatabase("h:\wf_pos_summary\pos_summary_2011.accdb ", , True)

and I got  a run time error of "unrecognized database format"

Commented:
For accdb files use this reference in your VB project: "MS Office 12.0 Access Database Engine Object Library"

Author

Commented:
This is the best web site. I cannot tell you how many times I have been helped by this site.  This solution was easy to follow and worked like a charm.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.