I'm new to Access, I use it as a basic database but my job asked if i can solve a problem from a retired employee that created a Access Macro filled exe.
I tired to fix it, but ended up creating a new one. The new one only works if a txt file is present on my C drive. I cant get it to work if those conditions are met.
I'm thinking of creating a new Access exe which looks to see if that txt file is present, if that txt file exists, use ACCESS 1 if it doesnt, use ACCESS 2.
How would i start? I'm using ACCESS 2019.