How can I view the metadata for a Microsoft Access 2013 table?
How can I view the metadata(data dictionary) for a Microsoft Access 2013 table?
Solution
If you want to retrieve the access database metadata this may be helpful:
Every microsoft access database contains a system table named MSysObjects. This tables contains this database metadata. You can get all objects with there creation date and last update date.
You can list all Objects in an Access Database using the following query:
SELECT Name, DateCreate, DateUpdate,
iif(LEFT(Name, 4) = 'MSys','System Table',
iif(type = 2,'System Object',
iif(type = 3,'System Object',
iif(type = 8,'System Object',
iif(type = 4,'Linked Table (ODBC)',
iif(type = 1,'Table',
iif(type = 6, 'Linked Table (MsAccess/MsExcel)',
iif(type = 5,'Query',
iif(type = -32768,'Form',
iif(type = -32764,'Report',
iif(type=-32766,'Macro',
iif(type = -32761,'Module',
iif(type = -32756,'Page',
iif(type = -32758,'User','Unknown')))))))))))))) as ObjectType
FROM MSysObjects WHERE LEFT(Name, 1) <> '~'
If you don't want to show system objects you can add these conditions to the where clause:
AND LEFT(Name, 4) <> 'MSys' AND Type IN (1, 5, 4, 6, -32768, -32764, -32766, -32761,-32756,-32758)
Also i created an application that retrieve data from access database, Which i created a new Git-repository for it
- Access 2010 Forms VBA - Set Focus to Record on image click
- Expressing basic Access query criteria as regular expressions
- Where is acedao.dll?
- How to show the same field value from another entity attributes
- Convert Foxpro .dbf file to excel via ms access
- Opening table shows "Enter parameter value"
- Init Date variable with null value
- Button To Add Text and a new line
- Ms Access series numbering that resets monthly and yearly
- Recordset.Sort method not sorting
- How can I remove a link to an excel document from a previous 'DoCmd.TransferSpreadsheet acLink ..' command?
- MS Access Edge Browser Control to call a telephone number (W10)
- Creating a relationship with a calculated field
- how to count the number of records with ExecuteScalar if more than one then cannot insert into in the MS Access database on vb.net
- How to list DataMacro objects in an Access database?
- Inner join returning duplicate records access sql
- The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data
- How can I always round up decimal values to the nearest integer value?
- Word VBA insert multiple images and captions at bookmarked location in template document from Access
- Conversion from string to Date with PM is not valid in VB.Net
- Access change dates on other date fields based on date in first date field
- How do I force MS Access to retain its SQL formatting?
- PYODBC InterfaceError- Data source name not found
- Long text (> 255 chars) truncated while importing and adding to existing table in MS Access 2013
- SQL Issue: calculated query column won't recognize day interval in DateDiff?
- Get Query Type property in VBA
- How do I prevent an error 2101 in Access when I have a button to save a record on a form?
- Distance using Longitude and Latitude (Excel vba to Access vba)
- Access Duplicate Table with properties like Lookup Field
- Adding attachment to Outlook.MailItem using unbound textbox entry