Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

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
0answers
26 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
25 views

is there a piece of software that is a hybrid between Mendeley and Microsoft access?

I'm wondering if there's a piece of software that's a hybrid between Microsoft access and Mendeley. I'm working on a database for work, and am new to database management. It has recently become very ...
0
votes
2answers
11 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
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 ...
1
vote
0answers
8 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 ...
0
votes
0answers
11 views

RStudio or SQL for data cleaning

I am wanting to detect corrupt and inaccurate records to check for data quality from large data sets that originate from Microsoft Access and Excel. Things I would like to check for: Validity which ...
0
votes
0answers
8 views

Free, multi-user searchable list with categories

I have been asked to create a "searchable" list of referral sources that could be: Updated and accessed by multiple people Easily searched The team I'm with hates Access. None are very tech savvy. ...
0
votes
0answers
9 views

Need (working) utility to find a string across entire access database

I installed a utility called "Search Wizard" by Dev Ashish and Terry Kreft. But it doesn't work right. It is supposed to search across the entire database, including forms, code, queries, reports, etc....
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 ...
0
votes
1answer
16 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
1answer
30 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 ...
1
vote
0answers
17 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.
3
votes
1answer
74 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 ...
2
votes
2answers
52 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
4answers
107 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 ...
4
votes
1answer
279 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 ...
0
votes
2answers
13k 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 ...
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,...
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 ...