Database diagram for linked server tables I run Microsoft SQL Server Express 64-bit version 14.0.2027.2 (X64) on Windows 10 Pro 10.

I created a linked server connecting tables from a Microsoft Access (mdb) database to Server Objects/Linked Servers on my SQL Server Express instance. All the linked tables seem to be working well.

I would like to create a Database Diagram for the linked tables. Since I am new to SQL Server, as far as I know ER diagram is possible to make only for the local database.

Is there any option how to make an ER diagram for linked server tables?

If not (when diagram is allowed only for native database/tables), is there any possibility to link tables directly into a native SQL Server database and then create diagram for tables?
There's no way to do this with the native tools within SQL Server Management Studio. You could get a third party tool like ER/Studio, but even that won't automatically model the linked tables. You'll have to enter them manually. External tables just aren't considered to be a part of the fundamental model of a given database. They're external, additional, other.