Re: [MSAccessProfessionals] Access Database Documentation Help

Hi Jim

 

If I remember correctly, PeopleSoft uses SQL Server as a backend. There are lots of analyzing software that could help you track down the fields/tables. Back when I was a SQL Server DBA I used https://www.apexsql.com/ tools, but knowing Microsoft's penchant to gobble up other company's ideas, SQL Server might already have something built in.

 

Regards,

Bill Mosca

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Jim Wagner
Sent: Friday, October 14, 2022 10:03 AM
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] Access Database Documentation Help

 

Hello all,

For the last 17 years I have worked at this job, we have had access to specific data that we have built queries and reports based on this data and make hiring and leave decisions on. Somewhere along the way we now have Data Stewards that have decided to take this data away. Even though it can be seen in PeopleSoft. I guess these data stewards after 17+ years have decided to do their job and deem these columns too sensitive for eyes in a table but not in PeopleSoft. This change is happening pretty quickly so I am really nervous that I will be without data soon.

My question now is with 15 databases that I support, how do I find out where these fields are in every query and report? I download the data using Alteryx into Excel and then import the data into Access and then send the updated tables to each of the respective databases. 

I could use the documenter and do a search on the PDF but if there is another way to find these fields, I am listening, intently to others for guidance. 

Thank You

Jim Wagner