I am attempting to export data but I am getting this error message saying Object 'tempAgency' already exists. Any help would be much appreciated.
Thanks!
I am attempting to export data but I am getting this error message saying Object 'tempAgency' already exists. Any help would be much appreciated.
Thanks!
That's not a lot of info. The simplest answer is that "tempAgency" already exists, but what is it? A spreadsheet? A view or some other member of a collection? A property?
You are exporting via ADO code?
??
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
I apologize but I am not savvy with Access.
I am exporting a list of names which gets generated into a text file along with one other text file named agency.
You didn't answer what tempAgency is so I'm going to guess it's a file and your export is telling you that the file already exists when you try to run it. If you deleted that file, it would probably work just once. If not, you can always post the export code or zip a copy of the db and post it here.
Even if you don't know Access, you can probably read and answer questions, yes? That is always a good habit to adopt in a forum because the purpose of the questions is to narrow down the possibilities.
I am not 100% sure if tempAgency is the agency text file.
I've already attempted to search for tempagency and could not locate it as I was going to delete the file.
Then I have no idea, based on the limited information. As I stated, you have the option to post relevant code or a db copy. I think that's the only way progress can be made.