Forum Discussion
Rudz
Kudo Collector
5 years ago[DataFormat.Error] The file name is longer than the system-defined maximum length
I am trying to find all Microsoft Access databases on a drive. The query below works until the path gets too long and then dies with: [DataFormat.Error] The file name Desk\..._5387851 d-7b20-44f7...
- 5 years ago
hi Rudz
Open a command prompt and then run a dir command to search for the files. Output the search results to a file that you can open in PQ.
Example command, change the file extension accordingly
dir *.accdb /s /b > dbfiles.txtThis will give you all files with the extension .accdb in all subdirectories off the directory the command was executed in, and stores the results in the file dbfiles.txt
Results in the file look like this
d:\main.accdb d:\temp\myfile.accdb d:\temp\backup\accounts.accdbRegards
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
mohdmohideen200
Helper I
1 year agoThe space before the 1 at the end of the file name is worth noting, as it could be a unintended space.