Within Microsoft Access 2019 is there a way to see or script out all Tables definitions keys/constraints/indexes, etc...?

Question

Within Microsoft Access 2019 is there a way to see or script out all Tables definitions keys/constraints/indexes, etc...?

techresearch7777777 1,981

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.

Accepted answer

1 additional answer

Your answer

Answer 1

Ken Sheridan 2,851

Take a look at the Database Documenter in the Analyze area of the Database Tools ribbon.

techresearch7777777 1,981 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 2,061 Reputation points MVP

2024-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 30,046 Reputation points Microsoft External Staff

2024-10-01T07:04:13.33+00:00

Thanks for helping here. :)

Answer 2

Ken Sheridan 2,851

Take a look at the Database Documenter in the Analyze area of the Database Tools ribbon.

Share via

Within Microsoft Access 2019 is there a way to see or script out all Tables definitions keys/constraints/indexes, etc...?

1 additional answer

Your answer