Saving ODBC SQL database to "local" mdb?

Hi all,
Hoping someone can make me smart.
Have SQL Srv2000 database linked (ODBC) for query. Have my
completed Query. Want to save out THAT data to a local area for later
manipulation (in Access 2003) and changes (and NOT effect the 'real'
database on our SQL2000 srv) after which I will import this changed MDB
to another application entirely (that part is actually simple once I
configure the data to conform to the right names, etc... - column
naming, etc...).

Each time I try to 'save as' and select a folder on my Hard drive, I get
an error indicating the 'path or file' cannot be found -

I have the query open.
I try to save as.
I get that error.

Help. Thanks.

re: Saving ODBC SQL database to "local" mdb?

Doc wrote:
[color=blue]
> Hi all,
> Hoping someone can make me smart.
> Have SQL Srv2000 database linked (ODBC) for query. Have my
> completed Query. Want to save out THAT data to a local area for later
> manipulation (in Access 2003) and changes (and NOT effect the 'real'
> database on our SQL2000 srv)[/color]

Either rewrite as a make table query, or construct a new make table
query based on your above described query.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

re: Saving ODBC SQL database to "local" mdb?

Tim Marshall typed this:
[color=blue]
> Doc wrote:
>[color=green]
>> Hi all,
>> Hoping someone can make me smart.
>> Have SQL Srv2000 database linked (ODBC) for query. Have my
>> completed Query. Want to save out THAT data to a local area for later
>> manipulation (in Access 2003) and changes (and NOT effect the 'real'
>> database on our SQL2000 srv)[/color]
>
>
> Either rewrite as a make table query, or construct a new make table
> query based on your above described query.
>[/color]
Thanks Tim. I wasn't sure 'how' to do that but found a fairly complete
explanation in the 'help' section of Access 2003 - hoping it works like
it says ;^)

Thanks.

--
Rich "Doc" Colley

mailto: pc-dc-doc@nospam.comcast.net

re: Saving ODBC SQL database to "local" mdb?

Tim Marshall typed this:
[color=blue]
> Doc wrote:[color=green]
>> Hi all,
>> Hoping someone can make me smart.
>> Have SQL Srv2000 database linked (ODBC) for query. Have my
>> completed Query. Want to save out THAT data to a local area for later
>> manipulation (in Access 2003) and changes (and NOT effect the 'real'
>> database on our SQL2000 srv)[/color]
>
> Either rewrite as a make table query, or construct a new make table
> query based on your above described query.[/color]



Tim (second follow up),
Access 2000 is the application (my error, had been using a 2003 Office
system, but my lowest common denominator is Office 2000, so I'm using
that)...

Will that allow me to CD off the query, copy it to another system and
then "manipulate" it without effecting the 'production' database? Thanks
again.