>> Change data source

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jonathan - 27 May 2006 01:59 GMT

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)?

Signature

Many thanks
Jonathan Parminter

Reply to this Message

Arvin Meyer [MVP] - 27 May 2006 13:14 GMT

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

> 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.
[quoted text clipped - 5 lines]
> Many thanks
> Jonathan Parminter

Reply to this Message

Jonathan - 28 May 2006 20:45 GMT

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?

Signature

Many thanks
Jonathan Parminter

> 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.
[quoted text clipped - 16 lines]
> > Many thanks
> > Jonathan Parminter

Reply to this Message

Arvin Meyer [MVP] - 31 May 2006 01:18 GMT

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

> 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
[quoted text clipped - 23 lines]
> > > Many thanks
> > > Jonathan Parminter

Reply to this Message

Jonathan - 31 May 2006 09:05 GMT

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. :-)

Signature

Many thanks
Jonathan Parminter

> You should only need to do it once for each unique DSN. A DSN is saved with
> the extension .odc
[quoted text clipped - 37 lines]
> > > > Many thanks
> > > > Jonathan Parminter

Reply to this Message