Best way to get the data from multiple windows

Question

0.00/5 (No votes)

See more:

I want to get data from multiple windows systems, with multiple users currently I'm using access DB with share drive to get all the data is there any other database that can do similar work with internal data sharing.
i.e how we are getting data from the internet likewise need to get the data internal organization level or is there any other way?

What I have tried:

I'm currently using Access DB that is placed in the share drive this particular share drive is accessible by all the users, the front end will be excel from there data will be collected into access. instead of access DB can I use any other database that can collect internally.

Posted 27-Nov-20 1:56am

Naresh13Kumar

Updated 27-Nov-20 23:44pm

Add a Solution

Comments

CHill60 27-Nov-20 8:19am

There are lots of options, but could you explain your problem a bit clearer?
Options could be influenced by things like number of users, volume of data updates, size/volume of data, what kind of data, what other tools are available to you (e.g. Sharepoint)

Naresh13Kumar 27-Nov-20 9:57am

I'm using Excel (VBA user form) to get the user activity(front end application) and I'm currently storing it on Access DB. Instead of access DB, I would like to replicate it like a webpage where the information will be stored internet database likewise I should store the data in the database with excel (VBA User Form). (suggestion database would be any opensource would be better.)

CHill60 27-Nov-20 12:05pm

Why do you want to get rid of the Access DB? If it works, don't fix it! :laugh:
Data does not have to be stored on an "internet database" to be accessed from a browser-type application.
You are going to struggle to update an "internet database" from an Excel form.
As we are saying - try to explain your problem in another way, what data are you trying to capture for example and how many users, what volume of data.
In the meantime Microsoft are pushing Business Apps | Microsoft Power Apps[^] which might suite you

Naresh13Kumar 28-Nov-20 1:17am

I have given you the better explanation below

Dave Kreskowiak 27-Nov-20 11:17am

You're going to have to explain, in much greater detail, what you mean by "get the data from multiple windows". Without that, there's nothing anyone can tell you that's going to be useful.

Naresh13Kumar 28-Nov-20 1:16am

Sorry for the inconvenience, This is my scenario in my organization there are 5 HR's where will update the information of the interviewing details (like Name, year, date of interview, etc) currently I'm storing this information from excel to access, that access DB is stored in the shared folder where all the 5 can able to access the common shared folder, now I want to remove this access db and replace with any other database that can be accessible by these common user. Then the admin can export all the detail as report. this is my task to deliver.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RickZeeland · Answer 1 · 2020-11-27T23:44:00

An alternative might be to use Matrify, which can be self-hosted, the free version allows up to 3 users: cross-platform-personal-database-tools~matrify[^]
Sadly Matrify does not support calculations although it has a spreadsheet like look.

SeaTable[^] looks like a better option: free for up to 25 users and it supports calculations and Excel formulas.