MS Access question. I have a table of references and a query that returns case numbers. Another table lists the references and case numbers that are linked to each other. I need to find a way to list the references for each case that are NOT linked to that case. Difficulty level inside.
[more inside]
posted by charred husk
on Aug 11, 2010 -
6 answers
Are there uncommon ways to repair a corrupt MySQL table? I have a MySQL database that is experiencing some serious corruption. Using the
standard instructions, I have repaired all of the tables but one. No matter how many ways I try those instructions on the ornery table, in all cases either a) nothing happens or b) the data file is emptied, which is, obviously, not the result I want.
[more inside]
posted by Mo Nickels
on Nov 15, 2008 -
6 answers
Databasefilter: I'm a self-taught 'DBA' (I use quotes so as to not offend those who have this knowledge through a paid education). I'm having an efficiency problem with a few of my tables, and I thought maybe one or two of you could help.
[more inside]
posted by thanotopsis
on Jan 31, 2007 -
20 answers
Say I have a database
DATA.MDB
Inside
DATA.MDB there is a table called
ImageTable.
In this table is a field named
fimageOriginalFilePath. There are aprox 4000 entries.
Each entry holds an absolute path to a directory on the C drive. For example
C:\pictures\10131009
I want to automatically replace the first character of each entry with the letter F. So that each path points to the F drive.
Can it be done? Can it be done without MS Access? Can it be done by a person with no programing skills, knowledge of databases, or understanding of SQL queries and the like? If so, how? Thank you all.
[more inside]
posted by Grod
on Apr 17, 2004 -
14 answers
