Avatar of Matt Pinkston
Matt Pinkston asked on

Will Mongo work with Access?

Will access allow connection to MONGO DB?
Microsoft AccessMongoDBDatabasesNoSQL Databases

Avatar of undefined
Last Comment
John Tsioumpris

8/22/2022 - Mon
slightwv (䄆 Netminder)

It appears they have released an ODBC driver:
https://www.mongodb.com/blog/post/odbc-driver-for-the-mongodb-connector-for-business-intelligence 

Mentions Excel so I guess Access should work as well:
This driver makes it incredibly simple to connect to MongoDB data using analytics tools such as Microsoft Excel, Qlik, Microstrategy Desktop, Tableau Desktop, and PowerBI.
ste5an

Will it work, well, yes.

BUT: Mongo is NOSQL, thus non-relational. So not every you cannot transparently access every MongoDB with Access. If you use it on the otherhand just for storing relations in it, then it works.

Caveat: Also data type mapping can be harder in some cases.

If there is REST API running on it, then you may use that API to connect, but know using Access should be reconsidered. But it can be done.
ASKER
Matt Pinkston

looking for the easiest way to setup some interns to update some tables in mongo, what is the best way to setup and edit for data in mongo tables....
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
ste5an

There are no tables in MongoDB. Only collections and documents.

Thus there is imho no "general best way".

Compass as front-end works pretty well, but I requires some skills of your interns.

Depending on what your interns need to do, implementing a simple UI in .NET or another front-end technology is not that hard. Cause also using Access requires some development time.
ASKER CERTIFIED SOLUTION
John Tsioumpris

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question