My program is designed to take the users data and store it inside a Access db, access it to use and update as the data is modified.
I hear that MS Access is being discontinued in the near future, so I am wondering if there are other methods for data storage for a program?
I am looking for other methods besides MS Access for storing data that a user inputs into the program.
Naimish MakwanaPosted Apr 26, 2024, 11:47 AM
Absolutely, there are several alternatives to MS Access for data storage. Here are a few options:
ClickUp: This is a cloud-based tool that excels at tracking and organizing information. It’s a no-code solution with an intuitive user interface, and it can function as a desktop, mobile, or web application for data entry with multi-user access1.
LibreOffice - Base: This is a full-featured desktop database front end, designed to meet the needs of a broad array of users. It’s both free and open source2.
DBeaver: An open-source universal database tool that can connect to any database system2.
Claris FileMaker: A cross-platform relational database application2.
Airtable: A cloud-based software company that blends a traditional spreadsheet with a database2.
NocoDB: Turns any MySQL, PostgreSQL, SQL Server, SQLite & MariaDB into a smart-spreadsheet2.
MongoDB: A source-available cross-platform document-oriented database program3.
OpenOffice Base: A full-featured desktop database front end3.
Google Sheets: A spreadsheet program included as part of the free, web-based Google Docs Editors suite offered by Google3.
SQLite: A C library that provides a lightweight disk-based database3.
Each of these alternatives has its own strengths and weaknesses, so you’ll want to consider your specific needs when choosing a new data storage method. For example, if you need a free and open-source solution, LibreOffice - Base might be a good choice. If you prefer a cloud-based solution with an intuitive user interface, you might consider ClickUp or Airtable. If you need a more powerful database system, MongoDB or SQLite might be a good fit.
Thanks
RICHARD KNOXPosted Apr 28, 2024, 12:03 PM
I decided to try the SQLite to transfer the data into. I created the database in SQLiteStudio, transfered the data from the MS Access db, but I havent been able to get VS2019 to recognise the db created in SQLiteStudio. Is there a reference that I am missing, because I havent located much thru Google how to do that.
Jaydeep PatilPosted Apr 28, 2024, 7:37 AM
Hi Richard,
You can use any one of the following as per your use case and requirement.
Relational Databases: Structured data storage using SQL (e.g., MySQL, PostgreSQL).
NoSQL Databases:
Document Stores: Schema-less storage for flexible data (e.g., MongoDB).
Key-Value Stores: Simple data storage with fast retrieval (e.g., Redis, DynamoDB).
Column-Family Stores: Organizes data by columns for scalability (e.g., Cassandra).
Object Storage: Stores unstructured data (e.g., Amazon S3, Google Cloud Storage).
Caching Systems: Stores frequently accessed data in memory for performance (e.g., Redis, Memcached).
Search Indexes: Provides full-text search capabilities (e.g., Elasticsearch, Solr).
Graph Databases: manage interconnected data efficiently (e.g., Neo4j, ArangoDB).
In-Memory Databases: Fast primary storage solutions using memory (e.g., Redis, Memcached).
Jignesh KumarPosted Apr 27, 2024, 6:21 AM
Hello Richard,
You can use any one of these, check as per your requirement and have a look
Microsoft SQL Server: If you are looking for relational data then MS SQL is the best option. If you're already using Microsoft technologies, SQL Server is a robust relational database management system (RDBMS) that offers scalability, security features, and integration with other Microsoft products.
MySQL: An open-source relational database management system, MySQL is widely used for web applications. It's known for its speed, reliability, and ease of use.
MongoDB: MongoDB stores data in flexible, JSON-like documents. It's well-suited for applications with dynamic schemas and complex data structures.
File System: if you have a small amount of data. it stores data using text files, XML files, JSON files