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

A Visual Basic 6 (ugh) runtime file distributed with our internal Access database has been killed by a recent Windows security update. It's hard to gather support information (especially since VB6 is about 8.7 million years old) and so I was wondering if anyone out there can help me track down a more recent copy of the runtime file in question—msflxgrd.ocx—or otherwise fix the problem? [more inside]
posted by bcwinters on Mar 9, 2009 - 8 answers

I need a one-time conversion of a Access 2003 database file (.mdb) to an Access 2000 database file. I tried OpenOffice to no avail. [more inside]
posted by sandra_s on Feb 10, 2009 - 2 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

Microsoft Access: How do I save a 'global variable'? [more inside]
posted by SirStan on Sep 11, 2007 - 2 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

VBA assistance needed. I've got the automerge and print down, now to save it as a unique file... [more inside]
posted by TomMelee on May 15, 2007 - 11 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

I'm trying to get my head around some Microsoft Access security issues, and could use some help. [more inside]
posted by chill on Mar 15, 2007 - 4 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

Some colleagues are trying to export a MS Access report to Excel. Here's the error they get: [more inside]
posted by ao4047 on Nov 6, 2006 - 4 answers

Does anyone know where I can download television episode guides converted to Microsoft Access format? [more inside]
posted by feelinglistless on Aug 9, 2006 - 4 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

Working on an MS Access 2000 record-browsing form; the text fields all display as dark grey text on light grey background, no matter what colors or transparency are specified in the design. I've never seen this before. I've been running in circles for 2 hours. What am I missing?
posted by Tubes on Mar 2, 2006 - 12 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

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

How do I implement a more custom look for a Microsoft Access database? [more inside]
posted by benjh on Mar 9, 2005 - 3 answers

Microsoft Access: I might be asked to use Access to get information from a series of online EU databases, merge them and produce a series of reports. I know very little about this, and would have to get up to speec very quickly as the reports are time critical, and if they are not done well, there would be problems for the NGO who have approached me. Could anyone recommend some low cost books or other resources that could help me?
posted by quarsan on Feb 8, 2005 - 2 answers

i have some of my remote users in the office connect to our fileserver using webdav as a means to quickly (though admittadly not-securely) access and change documents, etc. it seems though, that since using windows xp SP2 it's been dirt slow. my user will click on a directory, and it will take no less than 10 seconds for the directory to be highlighted. that's not even attempting to open the directory - that'll take another two minutes or so. i'm trying to figure out what's exactly going on here. ideally i'll be switching to VPN soon, but in the meantime, i need to get this working properly again.

thanks!
posted by quadrinary on Sep 28, 2004 - 2 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