|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 27th, 2006, 01:59 AM
posted to microsoft.public.access.queries
|
|||
|
|||
Change data source
Hi, I have set up a bunch of queries linked to a test data source. I now want
to change the data source to the live data source. What are the steps that I need to follow in order to change the data source (DSN)? -- Many thanks Jonathan Parminter 
|
|
#2
May 27th, 2006, 01:14 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Change data source
Since DSNs are a named source. I simply delete the old one and create a new
one with the same name, but a different path to the data. -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads http://www.datastrat.com http://www.mvps.org/access "Jonathan" wrote in message ... Hi, I have set up a bunch of queries linked to a test data source. I now want to change the data source to the live data source. What are the steps that I need to follow in order to change the data source (DSN)? -- Many thanks Jonathan Parminter
|
|
#3
May 28th, 2006, 08:45 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Change data source
Thanks Arvin, so there is nothing that is a simple method from within the
Excel that a standard user can re-set as I'm not always available to do as you suggest? -- Many thanks Jonathan Parminter "Arvin Meyer [MVP]" wrote: Since DSNs are a named source. I simply delete the old one and create a new one with the same name, but a different path to the data. -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads http://www.datastrat.com http://www.mvps.org/access "Jonathan" wrote in message ... Hi, I have set up a bunch of queries linked to a test data source. I now want to change the data source to the live data source. What are the steps that I need to follow in order to change the data source (DSN)? -- Many thanks Jonathan Parminter
|
|
#4
May 31st, 2006, 01:18 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Change data source
You should only need to do it once for each unique DSN. A DSN is saved with
the extension .odc Hunt them down on your machines and they should be easy to find and configure. -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads http://www.datastrat.com http://www.mvps.org/access "Jonathan" wrote in message ... Thanks Arvin, so there is nothing that is a simple method from within the Excel that a standard user can re-set as I'm not always available to do as you suggest? -- Many thanks Jonathan Parminter "Arvin Meyer [MVP]" wrote: Since DSNs are a named source. I simply delete the old one and create a new one with the same name, but a different path to the data. -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads http://www.datastrat.com http://www.mvps.org/access "Jonathan" wrote in message ... Hi, I have set up a bunch of queries linked to a test data source. I now want to change the data source to the live data source. What are the steps that I need to follow in order to change the data source (DSN)? -- Many thanks Jonathan Parminter
|
|
#5
May 31st, 2006, 09:05 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Change data source
Thanks Arvin. I have an .xla with a custom menu. I've just added into this
the ability to change DSN before creating query tables. I do appreciate your help. :-) -- Many thanks Jonathan Parminter "Arvin Meyer [MVP]" wrote: You should only need to do it once for each unique DSN. A DSN is saved with the extension .odc Hunt them down on your machines and they should be easy to find and configure. -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads http://www.datastrat.com http://www.mvps.org/access "Jonathan" wrote in message ... Thanks Arvin, so there is nothing that is a simple method from within the Excel that a standard user can re-set as I'm not always available to do as you suggest? -- Many thanks Jonathan Parminter "Arvin Meyer [MVP]" wrote: Since DSNs are a named source. I simply delete the old one and create a new one with the same name, but a different path to the data. -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads http://www.datastrat.com http://www.mvps.org/access "Jonathan" wrote in message ... Hi, I have set up a bunch of queries linked to a test data source. I now want to change the data source to the live data source. What are the steps that I need to follow in order to change the data source (DSN)? -- Many thanks Jonathan Parminter
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| from text to combo | brown_eyes | Using Forms | 8 | April 13th, 2006 04:22 PM |
| Consecuitive Employment time employed | Dave E | Running & Setting Up Queries | 9 | February 7th, 2006 05:06 PM |
| Format on data to import to Access tables? (I need your advice) | Niklas Östergren | General Discussion | 5 | December 13th, 2004 02:54 PM |
| Data Source issues. ??data.access.pages | Phil | Database Design | 2 | October 11th, 2004 02:42 AM |
| Mial merge data base problems | Rachael | Mailmerge | 16 | May 21st, 2004 06:22 PM |
Linear Mode
