I developed a query that reads data from MS Access. It works fine but I have changed the name of the folder where the files are and it doesn´t work anymore.
Someone can help me? Thanks.
I developed a query that reads data from MS Access. It works fine but I have changed the name of the folder where the files are and it doesn´t work anymore.
Someone can help me? Thanks.
Try this:
Copy the renamed folder and its contents into the location the query is referencing.
Rename the folder to the previous name.
Now, when you edit the query, MS Query will locate the folder and the data source. Click the [SQL] button and edit the FROM line so it references the new folder name.
Then, delete the unnecessary folder.
Does that help?
Regards,
Ron
Don
Thanks for your help.
It worked but I lost the information about the parameters.
In fact, I need to develop the solution in a computer and deploy it in another computer, with differents folders.
Best regards,
Osmar
Here's a thought...(un-tested)
While I'm generally not a fan of mapped network drives, maybe this is an instance where it could work for you. You could map a network drive to the folder location and use that for the query source.
Example:
With a source located at \\Servername\MajorFolder\MinorFolder\MyData.mdb
Map M:\ to \\Servername\MajorFolder\MinorFolder\
The query source would now be: M:\MyData.mdb
Then, create an M:\ drive on each destination computer that refers to the mdb file location that they will be using.
Note though, the mdb file name will need to be consistent.
Is that something you can work with?
Regards,
Ron
I will work on it.
Thanks a lot!
Osmar
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks