By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,434 Members | 2,963 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,434 IT Pros & Developers. It's quick & easy.

Issue with Make-table query - Will this HURT?

P: n/a
Doc
Per earlier post, I am trying to save 'out' production data from a
program called Solomon - basically (I think) this was /is an Access/Sql
based program.
We are updating to different application and I need to bring over ONLY
certain DATA.

When I did an ODBC link to the DB all the tables are present.
I linked the three or four tables and have my fields (these are the ones
I want to modify for LATER import into the new application)

When I 'tried' (earlier) to modify the data, if effected the ACTIVE
production DB - I had not saved my work so returning to 'original' state
was easy.

It was suggested to create a "make-table query" (I have Access 2000 and
2003 so I can use either to do this??) - I did a 'copy' of the query I
had (that linked the three important tables and fields within) - so
I made the "make-table query" from that.

NOW, when I go to OPEN that make-table, I get a WARNING that says...
"You are About to run a make-table query that will modify data in your
table." Are you sure you want to run this type of action query? -

I have not run it as I don't know if this means I am going to muck up
the real production data or not??? HELP. thanks.
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
No. all you're doing when you re-run the maketable query is
potentially overwriting the existing table in your *local* Access
database. If you don't need the existing data, you can do one of two
things.
1. toggle warnings before and after running the query
2. toggle warnings off, truncate existing table, append records to
table, turn warnings on.

Basically all the warnings stuff does is turns off the "you are about
to..." warning.

Nov 13 '05 #2

P: n/a
Doc
pi********@hotmail.com typed this:
No. all you're doing when you re-run the maketable query is
potentially overwriting the existing table in your *local* Access
database. If you don't need the existing data, you can do one of two
things.
1. toggle warnings before and after running the query
2. toggle warnings off, truncate existing table, append records to
table, turn warnings on.

Basically all the warnings stuff does is turns off the "you are about
to..." warning.

Thanks.. I guess I was NOT sure I was using (with ODBC functionally
linking) a "local" database?
I have decided to just export the tables directly out of SQL (using DTS)
into an empty MdB 'locally' - aside from one invalid arguement while
accessing a table modified by someone else, I'm having some luck. Cannot
hurt the 'real stuff'. Thanks.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.