[RESOLVED] Getting the field description in Access Database

[dinosaur_uk]

Is this possible?

[jmcilhinney]

Not by SQL, unless perhaps by querying system tables. Which system table they might be stored in I don't know.

[dinosaur_uk]

ok no problem...thank you very much.

[RobDog888]

Yes, its possible but easiest with using the Access Object Model.

Add a reference to Microsoft Access xx.0 Object Library
Or
Use Late Binding for multiple version support but no intellisense.

Dim oApp As Access.Application 'Or Object for Late Binding

oApp = CreateObject("Access.Application")
oApp.OpenCurrentDatabase("C:\Robdog888.mdb")
MessageBox.Show(oApp.CurrentDb.TableDefs("Table1").Properties("Description").Value.ToString)
oApp.CloseCurrentDatabase()
oApp.Quit()
oApp = Nothing