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

Overloaded with spreadsheets! Looking for an online database program that has bug-tracking features. [more inside]
posted by mammary16 on Nov 23, 2009 - 4 answers

Please point me to a comprehensive resource of designing databases to be published with Filemaker Instant Web Publishing. [more inside]
posted by lalex on Nov 18, 2009 - 3 answers

Is there any simple database that can operate "over" raw text files? [more inside]
posted by mjklin on Nov 17, 2009 - 2 answers

I work in a major US art museum, helping to manage the database that is used to keep track of the art, exhibitions, etc. In the context of this job, I have developed, quite unintentionally, a decent working knowledge of Crystal Reports and a little bit of experience with SQL queries. Other than this museum-specific experience, I know little about the world of databases. What other jobs could I do building on these skills, what else would I need to learn to do those jobs, and how should I go about learning it? [more inside]
posted by doift on Nov 9, 2009 - 7 answers

In the Seattle/Snohomish area. Which schools provide good training in beginning SQL, or database design, or IT project management? [more inside]
posted by valannc on Oct 31, 2009 - 2 answers

Need help getting to 3NF when one attribute is functionally dependent on a combination of other attributes. [more inside]
posted by alex.dudley on Oct 29, 2009 - 10 answers

Filemaker Filter. I need help publishing a database to a leased server- preferably in the way that my boss can access it on his iPhone. [more inside]
posted by lifeofthunder on Oct 27, 2009 - 1 answer

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

Where can I find a database of cookbook indexes? [more inside]
posted by chefscotticus on Oct 3, 2009 - 4 answers

I am doing research in a Hematology/Oncology genetics lab and I am looking for computer software that can organize my research data (e.g., new project, dates and findings, results, task management) and was created for scientific purposes. I have a macbook (black), OSX10.6, 2.4 GHz Intel Core 2 Duo, 4GB ram. I am looking for one that is free or inexpensive (under $150). Any help? Thanks.
posted by jbreyfogle on Oct 1, 2009 - 5 answers

Are there any Access-like tools for building data access pages in a web+sql format? [more inside]
posted by gjc on Sep 25, 2009 - 3 answers

Please show me the most informative and useful online event listings you use. [more inside]
posted by Brandon Blatcher on Sep 23, 2009 - 3 answers

What should I use to create a database that specific people can access and contribute to remotely? [more inside]
posted by nayrb5 on Sep 12, 2009 - 9 answers

I have up to 150 million product names, I need to match each of them to 1 or more codes. How can I do this very quickly and with little infrastructure requirements? [more inside]
posted by bottlebrushtree on Sep 3, 2009 - 6 answers

Trying to locate early nineties database software that was fronted by a comedian, the names of either would help. [more inside]
posted by fluffycreature on Aug 20, 2009 - 7 answers

I have to compile a database for work to track about 300 separate data trends, but Access isn't cutting it. Suggestions for the next step up? [more inside]
posted by ricochet biscuit on Aug 19, 2009 - 10 answers

Help me find data visualization software like Tableau, where the visualizations can be viewed and interacted with by end users. But the rub is that I need it to work in the Macintosh environment. [more inside]
posted by crapples on Aug 19, 2009 - 1 answer

Is there a visual, gui database browser that would let me select a data field and show value of data field in a different table that is referenced by first data field? [more inside]
posted by rainy on Aug 13, 2009 - 6 answers

I want to turn my Google Docs spreadsheet of a route into something prettier with photos and stats - how to do it easily? [more inside]
posted by soulbarn on Aug 12, 2009 - 3 answers

Crazy excel help needed... again. Every month I have a monotonous series of tasks to perform in excel and I have exhausted all of the possibilities I know of to make things easier- more details inside. [more inside]
posted by TheBones on Aug 11, 2009 - 17 answers

How can I automate the migration of an existing MySQL database to a newer schema? [more inside]
posted by fightorflight on Aug 6, 2009 - 5 answers

I have two questions about setting up MS Access forms: 1) Currently, I have a form to enter the volunteer id, shift start time and shift stop time, but the client doesn't want to have to look up the id in a report. Is there a way to create a selection list from the volunteer's names? What other options are there? 2) On the "add/edit a volunteer" form, I'd like to be able to choose tasks from a selection list. The tasks table has id and name. The "tasks of volunteers" join table has volunteer id and task id. How do I set this up? I can't seem to get the right combination of configurations. [more inside]
posted by philomathoholic on Aug 5, 2009 - 7 answers

I need the hive's help. Which computer class should I choose: Database Management Systems or Database Management with MS Access? [more inside]
posted by atm on Jul 15, 2009 - 15 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

I'm looking for suggestions for an open source, web based club membership database. I want to be able to store contact information and keep track of who has paid their membership fees and who hasn't. [more inside]
posted by cornflake on Jul 10, 2009 - 2 answers

I'm a journalist with not much database programming experience. However I have been fascinated by the government and other agencies making their data available for developers to play with, and I think a newspaper could do wonders with this data. How do I get in on the fun? [more inside]
posted by Blandanomics on Jul 8, 2009 - 9 answers

I'm looking for a wiki-database hybrid that I can self host. [more inside]
posted by raamenchan on Jul 4, 2009 - 9 answers

Help me preserve my family's culinary heritage! Help me find a webapp for storing my Dad's favorite recipes. [more inside]
posted by perrce on Jul 3, 2009 - 8 answers

I'm looking for a piece of creative database software but am not sure how to search for it or if it even exists. Any suggestions welcomed. [more inside]
posted by jonathanbell on Jun 29, 2009 - 8 answers

I'm trying to map protests in the United States, but I'm grappling with data sources (and will eventually tangle with data management). Any ideas? [more inside]
posted by McBearclaw on Jun 11, 2009 - 5 answers

What is/are Pipeline Reports? [more inside]
posted by momzilla on May 28, 2009 - 6 answers

What's the best way to create a circulation database for a small-medium music score library? [more inside]
posted by those are my balloons on May 22, 2009 - 8 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

What efficient systems can one use to report different internal working data generated in a small / medium sized business - excel is too clumsy and a customized database based application feels like an overkill? [more inside]
posted by shalam on May 17, 2009 - 6 answers

Can anyone recommend some software to help me draw database diagrams the way that I want to draw them...? [more inside]
posted by twine42 on May 15, 2009 - 11 answers

existing python ADT structures within available libraries that are efficient at tagging schemas? [more inside]
posted by figTree on May 13, 2009 - 6 answers

Filemaker question: Is there a way to copy the structure of an existing database (all its fields, tables, settings, etc.) into a new database? [more inside]
posted by prior on May 12, 2009 - 8 answers

I'm an adult education teacher computerizing our attendance recording and reporting using MS Access. The reports need to be laid out in a particular way, and I'm not sure how to make that happen. Can you help me? [more inside]
posted by miraimatt on May 10, 2009 - 1 answer

I need an inventory management system to keep track of computer hardware and its users. [more inside]
posted by the matching mole on May 7, 2009 - 3 answers

Dirty database needs a good cleaning. But how? [more inside]
posted by greekphilosophy on May 5, 2009 - 14 answers

How are journalists and related professionals managing their contact lists these days? Dead tree contact books or digital wizardry, I want to know about both. [more inside]
posted by embrangled on Apr 30, 2009 - 11 answers

I have become comfortable with maintaining an inventory database using MS Access. I want something more powerful now. Where do I go? [more inside]
posted by wayofthedodo on Apr 26, 2009 - 19 answers

How to extract data automatically from a group of HTML pages to an Excel file or to a database? [more inside]
posted by elgilito on Apr 22, 2009 - 5 answers

Remote DBA services - has anyone used one of these for their business to outsource database administration? Could use some advice or references. [more inside]
posted by spicy_sockpuppet on Apr 22, 2009 - 14 answers

SQL query help. Given the (fictional but equivalent) table disk_status = computer_id:int, disk_id:int, datetime:datetime, temperature:float, rpm:int, I need to provide a table of disk status for a given computer_id, without knowing in advance how many disks there are. So if there were two disks for a particular computer, the result would have the header: datetime, disk_1_temperature, disk_1_rpm, disk_2_temperature, disk_2_rpm, disk_2_rpm [more inside]
posted by Nothing on Apr 16, 2009 - 25 answers

I need me a charity/community group directory for Glasgow that I can easily use to send out mass informational emails. [more inside]
posted by By The Grace of God on Apr 3, 2009 - 3 answers

Please help settle a bet: Is a spreadsheet a simple type of database, or are they fundamentally different things? [more inside]
posted by perrce on Apr 2, 2009 - 38 answers

I've been tasked with making a large amount of clinical research information we have easier to search and maintain. I have some questions about the best way to organize a database to do this, and in so doing see how much of my time I've wasted so far. [more inside]
posted by sevenless on Mar 30, 2009 - 8 answers

Where's my food? How to make a web ap that tells me how to find vegetarian food easily? [more inside]
posted by klangklangston on Mar 16, 2009 - 17 answers