display the access tables in the database in a list box

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

Visual Basic ClassicProgrammingVB Script

Last Comment

Cathy_Ryan

8/22/2022 - Mon

ASKER CERTIFIED SOLUTION

mkrohn

5/18/2011

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Cathy_Ryan

5/18/2011

ASKER

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"

mkrohn

5/18/2011

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

Cathy_Ryan

5/18/2011

ASKER

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.

Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!

Certified Expert Program

Credly Partnership

Udemy Partnership