I want to scan for standalone MS Access databases or I guess their file types?

[hirogen]

there's a project to move access databases to sql but it would be handy to scan our network for these databases, is this possible ?

Apologies if there's a report on this already had a quick look.

update - Ok i see there's an end of life button and I've clicked on MS access 2010 and MS Office access 2003, only a few machines have popped up, find that a bit strange, anyway can i search for the file type ? or do you have a specific sql report I can upload?

[CyberCitizen · Accepted solution]

Lansweeper doesn't search for file types with its scans.

You would need to create something like a deployment package that you run on each machine which checks the machine for database file types saving this information into a network share, you could then look through these files to see what access database files exist, then query. It's manual but could be done.

dir /s C:\*.mdb /b > "\\NETWORKSHARE\Logs\%COMPUTERNAME%.txt

You would need to look for both file extensions though mdb & accdb noting that mdb is used by other applications as well, not just access databases.

[hirogen]

Thank you sir!