I have a (hopefully easy) SQL question. I'm working in MS Access. Simplifying things a bit, I have a table with a TaskID, and a TaskStatusID. I want to get a list of each TaskID, and the newest TaskStatusID for each. (Details follow.) [more inside]
posted by inigo2 on Apr 21, 2009 - 7 answers

I have been asked to make a proposal to upsize an Access database to allow for a few more concurrent users (currently 10) and ideally improve the overall performance of the system. Am I getting in over my head? [more inside]
posted by cbrody on Mar 10, 2009 - 11 answers

We use clinical software that uses a MS SQL database. It has a five million records weighing in at 40 GB. The software doesn't have a mobility option but we need one. The company has it on their feature request list but its at least 3-5 years away. HELP. [more inside]
posted by bleucube on May 29, 2008 - 20 answers

Why isn't a query in Access returning the correct data compared to the equivalent query in SQL Server. More inside. [more inside]
posted by zackola on Mar 31, 2008 - 11 answers

How can a fool make a table in an Access database reference another table, using SQL and ASP? [more inside]
posted by dirtdirt on Jan 11, 2008 - 10 answers

Please help me with a giant SQL-ish mess. I need a better solution than MS Access for dealing with millions of records and building queries. [more inside]
posted by loquax on Nov 19, 2007 - 12 answers

Help me properly set up a very small relational db. This is a teensy bit over my head, so mainly I want to establish that I'm not going terribly wrong before I get too far into this. [more inside]
posted by desjardins on Jun 6, 2007 - 5 answers

Access SQL Query - I have multiple individuals each with an address. I need to make mailing labels, but if two or more people share an address, I would only like one label. [more inside]
posted by odinsdream on Apr 18, 2007 - 9 answers

Microsoft Access. An SQL "GROUP BY" query. How do I generate the mode of the values that it's grouping, when I want averages in other multiple fields? [more inside]
posted by Jimbob on Dec 13, 2006 - 3 answers

Access SQL: How to use a short list of numbers stored as text in a table cell as the criteria for a query? [more inside]
posted by Zetetics on Nov 6, 2006 - 9 answers

What is the easiest way to get this data into a MySQL database? [more inside]
posted by rlef98 on Nov 2, 2006 - 19 answers

How can I increment a value directly using SQL? [more inside]
posted by samstarling on Jul 17, 2006 - 3 answers

How can I import selected fields from one database into another database? [more inside]
posted by fvox13 on Mar 16, 2006 - 6 answers

What is the best alternative interface for an SQL server? [more inside]
posted by benjh on Jan 12, 2006 - 6 answers

How can I manage my databases that are exploding in size? Can I run SQL Server on my laptop? [more inside]
posted by benjh on Dec 9, 2005 - 9 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