Access 2003: I have this database that is truly awesome along with some equally awesome queries. Co-workers have recognized this awesomeness and want to start running their own queries but know nothing of Access. Is there a user-friendly option? [more inside]
posted on Jul 1, 2008 - 4 answers

What DBA certification should I pursue? MS, Oracle, something else? [more inside]
posted on Jan 15, 2008 - 3 answers

How do I add a 4,000 name MS Excel file to an existing MS Access database? [more inside]
posted on Jul 2, 2007 - 3 answers

How can I make Microsoft Access 2002 crank out organized web pages that conform to my design ideas? [more inside]
posted on May 14, 2007 - 2 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 on Dec 13, 2006 - 3 answers

Microsoft Access 2002 (Windows XP): Reports won't run due to (presumably) a date formatting issue; can't edit reports (or forms, or modules) to fix the (presumed) issue. [more inside]
posted on Jul 25, 2006 - 12 answers

OSX Databases: I have just migrated to Mac OSX from MS windows but have left behind several MS Access databases of varying complexity. [more inside]
posted on Jul 3, 2006 - 6 answers

Access DB Filter: Help me figure out how to make a pretty report. [more inside]
posted on Apr 4, 2006 - 3 answers

What is the best and/or most efficient website design software these days? [more inside]
posted on Feb 27, 2006 - 11 answers

Basic Microsoft Excel question. How do I join two databases together when they share elements but are not coextensively equal? (More) [more inside]
posted on Jan 22, 2006 - 8 answers

How difficult is it to switch from MS Access programming to Delphi? [more inside]
posted on Dec 12, 2005 - 17 answers

How can I manage my databases that are exploding in size? Can I run SQL Server on my laptop? [more inside]
posted on Dec 9, 2005 - 9 answers

I've been given 700 Word documents some of which I'll need to edit, based on content. The values to be queried are stored in named fields in the documents. [more inside]
posted on May 26, 2005 - 3 answers

UI design question -- I have a Windows application, basically a frontend to a database, whose interface has mututated over the years, through various "enhancements," to the point that it's almost unusable by the non-technical people for whom it exists. Anyone have any recommendations of firms that do UI makeovers? What could I get for around $5,000?
posted on May 3, 2004 - 4 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.
posted on Apr 17, 2004 - 15 answers