Mama mia! Some IT departments are filled with idiots.
Anyway, Access has had built-in mapping tools since 2010. Change your view to "Tables and Related views".
But if you want a truly effortless way to do this get Total Access Analyzer from fmsinc.com ; it's not cheap, but it will save you DAYS of tracing back.
Regards,
Bill Mosca,
Founder, MS_Access_Professionals
MS Access MVP 2006-2016
My Nothing-to-do-with-Access blog
From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Jim Wagner
Sent: Friday, October 14, 2022 3:41 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Access Database Documentation Help
Thank You Bill,
My tables are in Microsoft Access databases. So I am trying to find where they are in queries and reports. I guess I did not explain the situation well enough.
The tables from Alteryx exported to excel.
then I take those tables and distribute them to 15 databases that are specific for the table. I am not allowed to have a backend database because they do not trust it for all of the databases.
Years ago I asked for a SQL server to host the tables. I was told that SQL was not secure. I laughed so hard. Even though the University has SQL everywhere being used.
Jim Wagner
Tidak ada komentar:
Posting Komentar