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]

Re: On reading a MS Access MDB file

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

[Cor]

Re: On reading a MS Access MDB file

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]

Re: HLP: On reading a MS Access MDB file

Mr. B <User@NoWhere.C om> wrote in
news:l06jovsklt 4er03tepd3lsmmd 2mlr7ml3u@4ax.c om:
[color=blue]
> 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.[/color]

Bruce,

The OleDbConnection .GetOleDbSchema Table 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]

Re: HLP: On reading a MS Access MDB file

With Deft Fingers, "Chris R. Timmons" <crtimmons@X_NO SPAM_Xcrtimmons inc.com>
wrote:
[color=blue][color=green]
>> 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?[/color]
>
>The OleDbConnection .GetOleDbSchema Table method can be used to return
>schema info about Access tables.[/color]

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

Regards,

Bruce

[Mr. B]

Re: On reading a MS Access MDB file

With Deft Fingers, "Cor" <non@non.com> wrote:
[color=blue]
>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)[/color]

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]

Re: On reading a MS Access MDB file

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

[Mr. B]

Re: On reading a MS Access MDB file

With Deft Fingers, "Cor" <non@non.com> wrote:
[color=blue]
>Are you using Visual.Studio.N et 2002 or Visual.Studio.N et 2003?[/color]

2002... standard

Bruce

[Cor]

Re: On reading a MS Access MDB file

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

[Mr. B]

Re: On reading a MS Access MDB file

With Deft Fingers, "Cor" <non@non.com> wrote:
[color=blue]
>I could have know, that is not on that.
>Sorry maybe I should have asked first.[/color]

Not to worry... I've done some leg work and am slowly woking my way through
things. I first had to be able to open the @#$#$ file first to see the Form
names. On my way now. Still some 'growing' up to do (:

Regards,

Bruce