HLP: On reading a MS Access MDB file

[Mr. B]

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

[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

[Chris R. Timmons]

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/

[Mr. B]

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

[Mr. B]

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

[Cor]

Mr. B,
Are you using Visual.Studio.Net 2002 or Visual.Studio.Net 2003?
Cor

[Mr. B]

With Deft Fingers, "Cor" <no*@non.com> wrote:

Are you using Visual.Studio.Net 2002 or Visual.Studio.Net 2003?

2002... standard

Bruce

[Cor]

Mr.B,
I could have know, that is not on that.
Sorry maybe I should have asked first.
Cor