Access
A family of Microsoft relational database management systems designed for ease of use.
400 questions
Take a look at the Database Documenter in the Analyze area of the Database Tools ribbon.
Within Microsoft Access 2019 is there a way to see or script out all Tables definitions keys/constraints/indexes, etc...?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 45%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
techresearch7777777
1,881
Reputation points
Hello, within Microsoft Access 2019 is there a way to see or script out all Tables definitions keys/constraints/indexes, etc...?
Was given an Access DB and need to migrate and need to know if they are all simple straight forward stand alone Tables or if things will get more complicated having keys/constraints/indexes and other dependencies, etc.. to factor in.
Thanks in advance.
Access
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
881 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,175 questions
Accepted answer
-
Ken Sheridan 2,841 Reputation points2024-09-13T12:17:52.4266667+00:00 -
techresearch7777777 1,881 Reputation points
2024-09-13T18:49:10.9+00:00 Thanks bunch Ken for your helpful.
Yes I also came across that in running and seeing the output.
Looks like this will do for now...but wondering if there would be another way of getting like the CREATE sql scripts that contains the Table's other attributes (keys, constraints, triggers, etc...) kind of like what can be done within SQL Server.
Much appreciated.
-
Karl Donaubauer 1,891 Reputation points MVP2024-09-20T09:35:15.0566667+00:00 Hi,
For further analysis, you will need to either write respective VBA code (using DAO or ADO) or use a tool like Crystal's free Analyzer.
Servus
Karl
Access Forever News DevCon
Access-Entwickler-Konferenz AEK - 19./20.10. Nürnberg -
Emi Zhang-MSFT 25,621 Reputation points Microsoft Vendor2024-10-01T07:04:13.33+00:00 Thanks for helping here. :)
Sign in to comment -
1 additional answer
Sort by: Most helpful
-
Ken Sheridan 2,841 Reputation points
2024-09-13T12:19:09.0333333+00:00 Take a look at the Database Documenter in the Analyze area of the Database Tools ribbon.