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.
2  2090 
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.
pi********@hotm ail.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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Josh |
last post by:
I've just installed PHP on an IIS 5/W2K server. The installation was
succesful, as I can load a test.php file in the first website I setup
for PHP. However, the second website I setup for PHP will not work. I
keep getting a "you are not authorized to view this page" error,
despite having given the I_USR_machine account Read & Execute rights...
|
by: Dario Di Bella |
last post by:
Hi all,
we have the following urgent issue affecting our development team.
Initially we had one particular workstation that failed executing
queries on a DB2 database, raising an invalid date format exception
(SQLSTATE=22007). The same queries worked fine on all the other
workstations. The date format we want to use is "dd/mm/yyyy".After...
|
by: gmtonyhoyt |
last post by:
Okay, this one's a tough one for me to explain so this might take a few
e-mails to get the idea across. Here's what I got though.
I have this application running on a Sun/Solaris machine, written in
C, using the Sun Forte Developer 7 C 5.4 Compiler released a few years
ago. Not exactly old but, you get the picture.
Now, most if not all...
|
by: Sunny |
last post by:
Hi All,
I have a serious issue regarding classes scope and
visibility. In my application, i have a class
name "TextFile", and also a few other classes
like "TotalWords", "TotalLines" and etc.., which are
suppose to describe the structure of my main TextFile
class. Also i have created some custom collection classes,
which only take items of...
|
by: dm_dal |
last post by:
Is there a know issue surrounding the CheckBoxList control and it's
viewstate?
When my control is created, it's ListItems are checked as needed, but on a
postback, they loose their Selected status.
David
| | |
by: Mike |
last post by:
I'm trying to connect to a SQL 2000 db that is on another server then the
web server.
I setup and ID and PWD to access the SQL db via the code and it works
locally and when I put the
everything on the web server I get an Access denied to SQL Database.
what is causing this, what do i need to change
|
by: Ollie Riches |
last post by:
I'm looking into a production issue related to a windows service and
System.Timers.Timer. The background is the windows service uses a
System.Timers.Timer to periodically poll a directory location on a
network for files and then copies these files to another location (on
the network) AND then updates a record in the database. The file
copying...
|
by: GinnTech |
last post by:
I have a site that works perfectly in IE6 IE7 FF2 FF3 but not in the
latest Safari.
Here is the issue. I am attempting to call functions within a flash
object. When trying to attempt to retrieve the object to call the
functions IE6 IE7 FF2 FF3 all return Objects to work with. In Safari
a function is returned. Here is the code.
/
|
by: SAL |
last post by:
Hello,
I'm trying to include a popup in the ItemTemplate of a gridview row. The
ItemTemplate for the field contains a textbox and when the user clicks in
the textbox I want a popup panel to show allowing the user to make a
selection from the popup window. I have enabled AJAX extensions and have a
working sample outside of a gridview. However,...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |
