Is there a limit to the # of users who can share a Microsoft Access database across a network? [more inside]
posted by cg1 on Nov 23, 2009 - 12 answers

Microsoft Access question: I have an Access 2007 database hosted on a server. I have 10 staff members who use the database. I can get in the database even if someone else is in it. One of my coworkers cannot. Is this typical? [more inside]
posted by bibbit on Jul 14, 2009 - 9 answers

MS Access Alternatives? I have a user that needs to keep data in a relational database, but I'd like to advise her against Access because of it's various limitations. She has no programming knowledge. Any suggestions? [more inside]
posted by SpecialK on May 19, 2009 - 13 answers

I can't believe I don't know how to select many checkboxes in Microsoft Access... [more inside]
posted by Foam Pants on Oct 7, 2008 - 9 answers

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 by Smarson on Jul 1, 2008 - 4 answers

What DBA certification should I pursue? MS, Oracle, something else? [more inside]
posted by davar 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 by 2bucksplus 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 by Servo5678 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 by Jimbob 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 by Gator 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 by jonesor on Jul 3, 2006 - 6 answers

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

What is the best and/or most efficient website design software these days? [more inside]
posted by Servo5678 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 by Mr. Justice on Jan 22, 2006 - 8 answers

How difficult is it to switch from MS Access programming to Delphi? [more inside]
posted by elgilito 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 by benjh 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 by punilux 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 by stupidsexyFlanders 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. [more inside]
posted by Grod on Apr 17, 2004 - 14 answers