search

mattn / go-adodb

Microsoft ActiveX Object DataBase driver for go that using exp/sql
http://mattn.kaoriya.net/
MIT License
142 stars 36 forks source link

List of tables and fields #32

Closed flibustenet closed 6 years ago

flibustenet commented 6 years ago

Hi,

I'm looking for a way to extract tables and fields of a MSAccess database without making query. I wonder if go-adodb can help me for that or if i should look at go-ole ? (i'm not very confortable with windows api) Maybe there is an example for this ?

Thanks

mattn commented 6 years ago

I'm not sure but could you please try this?

SELECT MSysObjects.Type, MSysObjects.Name, MSysObjects.Flags 
FROM MSysObjects 
where MSysObjects.Flags=0 AND Type=1 
ORDER BY MSysObjects.Type, MSysObjects.Name;
flibustenet commented 6 years ago

It said insufficient permissions, it's why i think i need to use ado directly

flibustenet commented 6 years ago

Will look at ado documentation directly