Database Query
 

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.


--
Osmar Mateus
------------------------------------------------------------------------
Osmar Mateus's Profile: http://www.excelforum.com/member.php...o&userid=30938
View this thread: http://www.excelforum.com/showthread...hreadid=506117

Database Query
 

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


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=506117

Database Query
 

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


--
Osmar Mateus
------------------------------------------------------------------------
Osmar Mateus's Profile: http://www.excelforum.com/member.php...o&userid=30938
View this thread: http://www.excelforum.com/showthread...hreadid=506117

Database Query
 

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


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=506117

Database Query
 

I will work on it.

Thanks a lot!

Osmar


--
Osmar Mateus
------------------------------------------------------------------------
Osmar Mateus's Profile: http://www.excelforum.com/member.php...o&userid=30938
View this thread: http://www.excelforum.com/showthread...hreadid=506117