Access 2016 - Viewing Excel sheets that link to my database queries (1 Viewer)

[Sketchin]

Hello,

The other day I could swear I came across an article that said a feature of Access 2016 was that you could view all of the spreadsheets that are linked to your database.

Was I imagining things? I can't for the life of me figure out how to do this.

 

[Ranman256]

you can link each sheet as a separate table.

 

[Sketchin]

Perhaps I'm not explaining well enough.

I have a split database with the FE and BE on our internal network drive. People create their own spreadsheets and create tables that are linked to my Access BE queries.

What I THINK I can do, is view all of the spreadsheets that are linked to my database.