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
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
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
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
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
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
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 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
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
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 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
