Join 3,382 readers in helping fund MetaFilter (Hide)

25 posts tagged with microsoft and database. (View popular tags)
Displaying 1 through 25 of 25. Subscribe:

Advice needed: moving a MS Access DB to the cloud..

Our small office uses a MS Access database daily for non profit work. The database is small enough where I'm not certain it warrants upgrading to SQL. Most of the work done in the database is remote (7 users total) so we are looking to move from a standalone PC w/remote access to the cloud. I would greatly appreciate any advice with regard to moving the DB to a cloud service provider that supports MS Access. One that is reliable, is relatively easy to admin e.g., backups and lastly, inexpensive.
posted by Sagres on Dec 3, 2012 - 4 answers

Database n00b - how long will this task take?

Estimate of how long it will take to develop an Access database. [more inside]
posted by sideofwry on Jul 31, 2012 - 8 answers

Accessible Access Training?

Microsoft Access Training/Classes in New York City (Manhattan), or your best suggestion of online materials. [more inside]
posted by rosswald on Jul 20, 2012 - 4 answers

Best practice in implementing a two-part unique identifier?

Best way to implement a two-part unique identifier in Access? [more inside]
posted by jsturgill on May 9, 2011 - 14 answers

How to use linking tables and bound objects in MS Access forms.

Microsoft Access 2007 form creation question. Hopefully not-too-wrongheaded and clearly described inside. [more inside]
posted by jsturgill on Aug 4, 2010 - 2 answers

How do i restrict access to MSSQL 2005?

Are there any phpmyadmin-like tools for Microsoft SQL Server 2005, or other options to restrict direct access to SQL, but leaving productivity and functionality intact? [more inside]
posted by mrw on Jun 18, 2010 - 4 answers

Access and Replication

Sharing an Access database among several small groups using replication. Doable? Am I on the right track? [more inside]
posted by Simon Barclay on May 3, 2010 - 20 answers

MS Access - Limit to # of shared users

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

MS Access...Access Problem

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

Alternatives to MS Access?

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

How do I record multiple options in Microsoft Access

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

Running Queries in MS Access for non-Access Users?

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

Best DBA certification?

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

Help me merge Excel with Access:

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 do I get MS Access to create organized web pages?

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

Selecting the MODE of a group of data in Microsoft Access

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

Using MS Access files with my Mac. How?

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

Help me figure out how to make a pretty report.

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?

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

MS Excel database question

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

Access VB to Delphi switch

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

Data Overload, How Do I Manage?

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

Querying the contents of Word documents.

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

Anyone have any recommendations of firms that do UI makeovers? What could I get for around $5,000?

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

How can I replace every occurrence of a drive letter with a different drive letter in a table in an Acess database?

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

Page: 1