[RESOLVED] Getting the field description in Access Database

Is this possible?

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

ok no problem...thank you very much.

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.

Code:

---

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

---