By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,683 Members | 1,398 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,683 IT Pros & Developers. It's quick & easy.

HLP: On reading a MS Access MDB file

P: n/a
Is there a 'trick' that one can use to open an MS Access data base file,
without knowing in advance the files fields? Or is it strickly a hit-and-miss
kinda deal?

I want to write a better user interface for some MDB files we have. But no
one knows anything about the files structures. So until I do I can't even
start.

Thanks in advance

Bruce
Nov 20 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
Cor
Hi Mr. B.
Normaly you can open a Access file in your server explorer from the IDE.
Then you see the whole structure of it.
(You can open it with View and then Server Explorer or Ctrl,Alt,S)

I hope this helps a little bit,

Cor
Nov 20 '05 #2

P: n/a
Mr. B <Us**@NoWhere.Com> wrote in
news:l0********************************@4ax.com:
Is there a 'trick' that one can use to open an MS Access data
base file, without knowing in advance the files fields? Or is
it strickly a hit-and-miss kinda deal?

I want to write a better user interface for some MDB files we
have. But no one knows anything about the files structures. So
until I do I can't even start.


Bruce,

The OleDbConnection.GetOleDbSchemaTable method can be used to return
schema info about Access tables.

Hope this helps.

Chris.
-------------
C.R. Timmons Consulting, Inc.
http://www.crtimmonsinc.com/
Nov 20 '05 #3

P: n/a
With Deft Fingers, "Chris R. Timmons" <crtimmons@X_NOSPAM_Xcrtimmonsinc.com>
wrote:
Is there a 'trick' that one can use to open an MS Access data
base file, without knowing in advance the files fields? Or is
it strickly a hit-and-miss kinda deal?


The OleDbConnection.GetOleDbSchemaTable method can be used to return
schema info about Access tables.


Thanks Chris... I'll try that! I don't have hardly any experience when it
comes to Data Bases.

Regards,

Bruce
Nov 20 '05 #4

P: n/a
With Deft Fingers, "Cor" <no*@non.com> wrote:
Normaly you can open a Access file in your server explorer from the IDE.
Then you see the whole structure of it.
(You can open it with View and then Server Explorer or Ctrl,Alt,S)


Hmmmm forgive my ignorance (I dont' have much in Data Base experience). But I
don't quit follow what you are saying :(

Regards,

Bruce
Nov 20 '05 #5

P: n/a
Cor
Mr. B,
Are you using Visual.Studio.Net 2002 or Visual.Studio.Net 2003?
Cor
Nov 20 '05 #6

P: n/a
With Deft Fingers, "Cor" <no*@non.com> wrote:
Are you using Visual.Studio.Net 2002 or Visual.Studio.Net 2003?


2002... standard

Bruce
Nov 20 '05 #7

P: n/a
Cor
Mr.B,
I could have know, that is not on that.
Sorry maybe I should have asked first.
Cor
Nov 20 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.