469,570 Members | 1,717 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,570 developers. It's quick & easy.

Saving ODBC SQL database to "local" mdb?

Doc
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.
Nov 13 '05 #1
3 1750
Doc wrote:
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)


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
Nov 13 '05 #2
Doc
Tim Marshall typed this:
Doc wrote:
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)

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

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*******@nospam.comcast.net
Nov 13 '05 #3
Doc
Tim Marshall typed this:
Doc wrote:
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)


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


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.
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by jack | last post: by
reply views Thread by Tom Clement | last post: by
3 posts views Thread by Zeljko | last post: by
reply views Thread by Ole Hanson | last post: by
3 posts views Thread by Robin Tucker | last post: by
1 post views Thread by princessjewel62 | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.