+ Reply to Thread
Results 1 to 5 of 5

Database Query-a query that reads data from MS Access

  1. #1
    Registered User
    Join Date
    01-29-2006
    Location
    Sao Paulo - Brazil
    Posts
    17

    Database Query-a query that reads data from MS Access

    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.

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996
    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

  3. #3
    Registered User
    Join Date
    01-29-2006
    Location
    Sao Paulo - Brazil
    Posts
    17
    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

  4. #4
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996
    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

  5. #5
    Registered User
    Join Date
    01-29-2006
    Location
    Sao Paulo - Brazil
    Posts
    17
    I will work on it.

    Thanks a lot!

    Osmar

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1