Matt Pinkston
asked on
Will Mongo work with Access?
Will access allow connection to MONGO DB?
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.
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
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....
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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: