Database Query

O

Osmar Mateus

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.
 
R

Ron Coderre

Try this:

Copy the renamed folder and its contents into the location the query i
referencing.
Rename the folder to the previous name.

Now, when you edit the query, MS Query will locate the folder and th
data source. Click the [SQL] button and edit the FROM line so i
references the new folder name.

Then, delete the unnecessary folder.

Does that help?

Regards,
Ro
 
O

Osmar Mateus

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
 
R

Ron Coderre

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
 
Top