[ Home  |  FAQ-Related Q&As  |  General Q&As  |  Answered Questions ]

    Search the Q&A Archives

I am trying to use VB.net to find database tables in an...

<< Back to general questions

Question by vbslave
Submitted on 4/5/2004
Related FAQ: N/A
Rating: Rate this question: Vote
I am trying to use VB.net to find database tables in an access database at runtime  and cannot find any way of doing it.

Any guidance will be appreciated.


Answer by Sohail
Submitted on 3/8/2006
Rating: Not yet rated Rate this answer: Vote
Open the Database in MS Access

1. Goto 'Tools' Menu and click 'Options'
2. Select 'View' Tab and check the 'System Objects' and click OK
3. Again Clikc 'Tools' and Goto 'Security'and then click 'User and Group Permissions'
4. Select 'Permissions' Tab and select 'MSysObjects' from 'Object Name'
5. Set the Permission of 'Read','Update' or any which you need.
6. After that you can use the following Query

"Select Name from MSysObjects where name='Table Name Here' and type=1"

 

Your answer will be published for anyone to see and rate.  Your answer will not be displayed immediately.  If you'd like to get expert points and benefit from positive ratings, please create a new account or login into an existing account below.


Your name or nickname:
If you'd like to create a new account or access your existing account, put in your password here:
Your answer:

FAQS.ORG reserves the right to edit your answer as to improve its clarity.  By submitting your answer you authorize FAQS.ORG to publish your answer on the WWW without any restrictions. You agree to hold harmless and indemnify FAQS.ORG against any claims, costs, or damages resulting from publishing your answer.

 

FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.

 

<< Back to general questions

[ Home  |  FAQ-Related Q&As  |  General Q&As  |  Answered Questions ]
© 2008 FAQS.ORG. All rights reserved.