I was quickly creating a program to search through a access database.
The idea is to filter the names and figure out the file location in the physical archive.
Though my query wizard is being rather annoying right now.
I did not use the manual connection like a lot of people do, but just used the add data sources option.
The access database fields are all text, except the id field.
Hopefully somone can give me a wakeup call and tell me what is going on because i am confused.
Img of query builder and error when trying to finish.