troubleshooting Question

Best Database for Inventory

Avatar of Solo Pascual
Solo Pascual asked on
DatabasesMicrosoft AccessNetworkingMicrosoft SQL Server
7 Comments2 Solutions191 ViewsLast Modified:
At some point in the next six months, I have to create a database for my department's inventory.  Currrently, the department is using Excel 2013.  The database only has about twenty fields.  However, Ideally, I would like several departments to use it.  In the past, I have used Access for these databases.  However, my concern is that sometimes in the past Access gets corrupted.  Especially, when using through the network.  I have not used Access in a while, so not sure if it is more robust now or not.  Or, I would like to know if any database expert may have a different opinion and/or suggestion.  Thanks in advance.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros