Reading Access database properties programatically

[josephchoufani]

Hi guys i need help with the following :

i'm trying to read an access database content on runtime. in other words i want to know the number of tables and how to retrieve them from a given access database.

thanx in advance.

 

[cjard]

I cant find the link that gave info about how to do this in sql.. use ADOX

http://doc.ddart.net/mssql/sql2000/html/mdacxml/htm/wpmigratingschema.htm

should be a start..

 

[josephchoufani]

Re:

thanx for the reply.
but i'm using Visual Studio 2005 and its not recognizing any of the objects.

maybe my request wasn't clear enough :

i'm working on a project that in some section i need to be able to view schema (Tables names, etc...) of an unknown access database.
the user would select the location of the database on the disk and i (the software) have to retrieve the tables names, their number, ...

any help would be appreciated

 

[cjard]

Yeah, that's ADOX.. Read around some more on it. You will need to reference the ADO Extensions dll, but I forget the exact name. Read up on ADOX

 

[josephchoufani]

do you know if it it's the ActiveX3DX3??????????

i found it in the "COM" tab in "Add Reference".

 

[josephchoufani]

i actually found it it's Microsoft ADO Ext 2.8 for DDL and Security

hope it'll work and thnx 4 the tip