How do you use MIcrosoft Access in place of Microsoft Query?

[Kim]

Hi,

I've been using Microsoft Query to bring data in from a specific data
source and had issues with it.

Is it possible to use Microsoft Access in its place and if so, how do
I do it so that I'm not pointing to a physical database on a physical
drive, but rather a pre-defined database? I want to know that because
I don't want the query to fail if a user has a drive mapped to a
different letter.

Thanks and I hope that's clear.

Kim

 

[Access Developer]

I've been using Microsoft Query to
bring data in from a specific data
source and had issues with it.

Bring data in "to what" or "to where"? What is a "specific data source" --
I can guess probably not "scribbled notes on a yellow pad", but that leaves
a great many options.

Is it possible to use Microsoft Access
in its place

Someone can give you a better answer with details to the questions above.
But, if you've been using Microsoft Query, the answer is "likely you could".
If the answer is "to bring data into Microsoft Excel from a source supported
by Microsof Access, the answer is "very likely".

and if so, how do I do it so
that I'm not pointing to a physical
database on a physical drive, but
rather a pre-defined database?

If you mean you know the name of the server, the names of the folders
heirarchy, and the name of the file, then you can us the Universal Naming
Convention (UNC) where you refer by name rather than drive.

I want to know that because I don't
want the query to fail if a user has
a drive mapped to a different letter.

You can also let the user locate the file to use. See the first entry in
the list at http://access.mvps.org/access/api/index.html for one approach.
A few items down the list, there's something that might be useful for
working with UNC.