Join 3,520 readers in helping fund MetaFilter (Hide)

6 posts tagged with table and database. (View popular tags)
Displaying 1 through 6 of 6. Subscribe:

A Link to the Reference Table Past

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

Using Base & numbering

Auto-generated numbers using Open Office base. Can it pick up where I left off? [more inside]
posted by Salmonberry on Oct 21, 2009 - 3 answers

Serious MySQL table repair help

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

My Kingdom for a DBA

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

Access form building

MS Access XP: Say I have 3 tables. [more inside]
posted by bigmusic on Mar 3, 2006 - 12 answers

How can I replace every occurrence of a drive letter with a different drive letter in a table in an Acess database?

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

Page: 1