Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Retrieve MS ACCESS 2000 table relations

Status
Not open for further replies.
tatsidis

tatsidis

Programmer
May 4, 2004
5
GR
Hi,
I want to retrieve through my VB application the table relations from an MS ACCESS 2000 database. I want to know which field of a table is a foreign key and to which field of whom table is connected. My program must run select queries on any .mdb file and I have to know if the sql that the user creates through a Wizard is correct and gives correct results.

I guess this will be achieved by OpenSchema method, but how exactly?

Sorry for any bad english, :)
 
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
via vb 6.0, please split access table
Replies
1
Views
310
strongm
strongm
sal21
  • Locked
  • Question
scraping table dont work 2
Replies
7
Views
442
strongm
strongm
sal21
  • Locked
  • Question
NOT FOR ME, get value from table web
Replies
1
Views
235
sal21
sal21
sal21
  • Locked
  • Question
scraping table in web page 3
2
Replies
24
Views
4K
strongm
strongm
2009luca
  • Locked
  • Question
TWO table with the same classname 1
Replies
3
Views
625
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top