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
0 votes
0 answers
5 views

Simple multi-user database/workflows in a browser (MS Access; smartsheet; powerapps?)

we are the cliche, using Excel and email to manage business processes. And it almost works. The only thing that is killing us is sharing Excel spreadsheets without we're seeing called "row level ...
user avatar
0 votes
0 answers
15 views

Ms Access encrypted .accdb convert so SQL Dump or Sqlite

Hi I have an Ms Access File .accdb encrypted and I need to convert it into a sql dump or a sqlite database on linux or mac. I have the password. I managed to convert in on windows with a utility and I ...
user avatar
  • 101
0 votes
1 answer
36 views

Why do you chose to not use Microsoft Access to develop applications? [closed]

Over the years I have heard from many Corporate IT departments and application developers as to why they chose to not use MS-Access, and even not allow it to be used, for developing applications. The ...
user avatar
3 votes
2 answers
74 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, ...
user avatar
1 vote
2 answers
149 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 ...
user avatar
  • 111
1 vote
0 answers
32 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 ...
user avatar
  • 111
2 votes
1 answer
76 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 ...
user avatar
  • 121
0 votes
0 answers
37 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 ...
user avatar
0 votes
2 answers
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 ...
user avatar
0 votes
0 answers
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 ...
user avatar
1 vote
0 answers
17 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 ...
user avatar
1 vote
1 answer
61 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 ...
user avatar
  • 13
0 votes
1 answer
22 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. ...
user avatar
  • 3
0 votes
2 answers
73 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....
user avatar
  • 1
0 votes
0 answers
29 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 ...
user avatar
1 vote
0 answers
27 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.
user avatar
  • 111
3 votes
1 answer
141 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 ...
user avatar
  • 31
2 votes
2 answers
60 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 ...
user avatar
2 votes
4 answers
140 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 ...
user avatar
4 votes
1 answer
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 ...
user avatar
  • 41
0 votes
2 answers
24k 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 ...
user avatar
1 vote
0 answers
50 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,...
user avatar
  • 111
3 votes
0 answers
57 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 ...
user avatar