M
mcl
I'm having problems trying to edit the values in a query results. I know
there are restrictions on that kind of stuff. The values are pulled right
out of a table. It's weather data that I pull out of an oracle table at work
using ODBC. I pull down the data for a specific station and put it into a
local table using a make table query. I then can crunch and display the
results all different ways. The data is raw data and there are errors in it.
I have queries set up using Dlookup where I can display, for example,
apparently erroneous temps looking at the time & temp just before and after.
If the value looks off I can just delete it. (Missing data is better than
erroneous data.)
We are transitioning from a tape based to all in oracle based data storage
(terabytes worth). To pull this data I used to use syncsort (if you know
what that is), then sas (if you know what that is) to create a text input
file for access. (using access 2003 BTW). I have the exact same queries set
up for that method and they work fine.
When trying to redo my "MS Access Surface Data Analysis Utility" (that's
what I call it (;-)), I just copied the one from the old method, & changed
all the tables, etc in the code to match the new stuff names. It works fine
except it will not let me delete the erroneous data.
Is this an "Access Quirk" thing? My old program started to do this once but
I had it backed up. So I just restored the backup and fixed the problem. I
can paste in the code here. But it's pretty long.
there are restrictions on that kind of stuff. The values are pulled right
out of a table. It's weather data that I pull out of an oracle table at work
using ODBC. I pull down the data for a specific station and put it into a
local table using a make table query. I then can crunch and display the
results all different ways. The data is raw data and there are errors in it.
I have queries set up using Dlookup where I can display, for example,
apparently erroneous temps looking at the time & temp just before and after.
If the value looks off I can just delete it. (Missing data is better than
erroneous data.)
We are transitioning from a tape based to all in oracle based data storage
(terabytes worth). To pull this data I used to use syncsort (if you know
what that is), then sas (if you know what that is) to create a text input
file for access. (using access 2003 BTW). I have the exact same queries set
up for that method and they work fine.
When trying to redo my "MS Access Surface Data Analysis Utility" (that's
what I call it (;-)), I just copied the one from the old method, & changed
all the tables, etc in the code to match the new stuff names. It works fine
except it will not let me delete the erroneous data.
Is this an "Access Quirk" thing? My old program started to do this once but
I had it backed up. So I just restored the backup and fixed the problem. I
can paste in the code here. But it's pretty long.