Questions tagged [microsoft-access]

Microsoft Access is a Database Management System from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications.

Filter by
Sorted by
Tagged with
4
votes
1answer
282 views

Mac capable Access similar database software

How do I create a database application that satisfies these requirements? It must be capable of running on windows and mac operating systems. It must be similar visually to excel. The user needs to ...
3
votes
2answers
63 views

Business Software Recommendations

We are currently using a MsOffice Access database for our company jobs lists and reporting for the last 15 years. We need to replace this system with something more stable for larger amounts of data, ...
3
votes
1answer
98 views

Linux alternative to MS Access

As for most office ultities on Linux I’ve been fine with LibreOffice, with Writer and Base capable of replacing their MS Office equivalent. However, LibreOffice Base can’t even come close to MS ...
3
votes
0answers
50 views

Microsoft Access to MySQL Database Converter

I am working on creating a basic master-detail application using VB.NET and MySQL, because of this I've tried to look for a simple master-detail application using VB.NET in the internet and I found ...
2
votes
2answers
55 views

Upgrading from MS Access

My company uses an old MS Access program to generate xml files. There are two users who perform maintenance/updates on this system, and a handful of others who use it to generate files. The program ...
2
votes
1answer
37 views

Mobile Friendly Data Entry App

I am trying to create a data entry "app" to collect daily readings across our site. Here are the three biggest constraints: Software - ideally, we would use some software within the Microsoft 365 ...
2
votes
4answers
123 views

Multi-user data editing software (think Excel/Access) with chart support?

I have a client (large corporation) with a broken Excel document where their staff enter some numbers, which are then displayed in some charts (like a sales dashboard). There is some validation on the ...
1
vote
2answers
21 views

Opening Access data in R on a mac

I have a load of old data on a Microsoft access (accdb) file. I can't open it on my mac, is there a way to open it directly in R? Is there a package that will let me do this? I don't need to open it ...
1
vote
0answers
25 views

Editing text documents before feeding database

I hope this is the correct section for my question. I need to paste 30 text files (they all have the same format, like 30 characters for the first column, 15 for the second one, and so on) one under ...
1
vote
0answers
13 views

Custom Client Server for small company to replace Access Database

I have been to find a solution that would require little developer skills after job is complete. This is to be a client server app that can also generate reports. The scenario is the Office worker ...
1
vote
1answer
55 views

Database for logging lost property

I am working at a University and we are looking for a new database system for logging and management of lost property items we receive. Due to the Universities rapid growth, the amount of items we ...
1
vote
0answers
24 views

Debian-compatible apps to open Microsoft Access file?

What packages are good for opening a 500+ MB .accdb file? I'm running Debian 9.3 on my computer.
1
vote
0answers
47 views

No Coding Required Database Management Tool (CRM?) Equivalent to Microsoft Access

I'm looking for software where I can manage a database created from excel/Google sheets. Ideally, I'd like to import the documents into the SQL database. I have experience in SQL so set it up, however,...
0
votes
2answers
15 views

VBA in Excel vs Access for data conversion

We are upgrading our enterprise software and part of that effort I have to perform sales order (data) conversion from legacy to new software. I have moderate experience with macros/VBA in excel and I ...
0
votes
2answers
20k views

How do you create a parent-child tree with table/excel data?

I'm using access to model a relational database. I have the following data in a 2 column format: The result should generate a tree/bullet point diagram that looks like this: A B C D G E F ...
0
votes
0answers
28 views

Which db should I use for a small project?

I`ve created a small project about a dentist. It is built with ASP and for my db I`m using MS Access. I think that he will add more or less about 1000-1500 records per year. My fear is that there ...
0
votes
0answers
15 views

Access Office for multi OS

We would need advice on 1 project that we want to achieve Currently we create BDD under Access (microsoft office), but some customers want to use the database on Mac or smartphone, the problem is ...
0
votes
1answer
17 views

Dynamic web application based on MS Access

I am given MS Access file, based on which I need to create a web application with some statistics. The end user is downloading this MS Access file from some third party application, say once a week. ...
0
votes
2answers
52 views

Need a database for a single-user app to sync data across computers without storing on the internet

Need suggestions for a database. I'm tasked to write a C# desktop application for a small business. The business owner does not want his data to be stored on the internet. He has two desktop computers....
0
votes
0answers
25 views

Software/system to create user-friendly relational database management system, similar to MS Access

We have a company that delivers educational programs to other companies. With excel sheets we register who is taking which course and how much they owe us, etc. Every tab in the sheet is a different ...