HLP: On reading a MS Access MDB file

  • Thread starter Thread starter Mr. B
  • Start date Start date
M

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
 
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
 
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.
Click to expand...

Bruce,

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

Hope this helps.

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

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

Regards,

Bruce
 
Cor said:
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)
Click to expand...

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 said:
I could have know, that is not on that.
Sorry maybe I should have asked first.
Click to expand...

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
 
Back
Top