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.
26
questions
0
votes
2
answers
36
views
MS Access as a tool for manipulating/converting data instead of storing data
I was asked to create a database and based on the information I was given assumed that it would be used for storing data and would be used by multiple people. Now I'm realizing that's not the case. ...
- 3
0
votes
0
answers
18
views
Cross platform software for Access application
I have written a personal finance app in MS Acess and want to convert it to a cross platform app for Windows,Mac, Chrome, IOS and Android. What are my best options? In addition to Access, I have ...
0
votes
0
answers
11
views
Access to sql server synchronisation
I have a legacy VB system that creates a new access database for every job in our system, for example 1.Mdb, 2.mdb, 3.mdb I want to automatically write the details from these databases to a ms sql ...
1
vote
0
answers
9
views
Best front end software manager for local queries
I am starting a little personal project and looking for a front end manager. I was previously using Microsoft Access but ran into the 2 gig limit and decided to move to a new software. I have looked ...
1
vote
1
answer
33
views
MySQL interface with copy/paste functionality and conditional formatting
I am looking for a MySQL UI with some spreadsheet-like features.
We need:
Copy & paste functionality
Conditional formatting
I have tested a lot of tools and have not found exactly what we need.
...
- 113
0
votes
1
answer
40
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 ...
- 101
3
votes
2
answers
80
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, ...
- 31
1
vote
2
answers
419
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 ...
- 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 ...
- 111
3
votes
1
answer
122
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 ...
- 131
0
votes
0
answers
39
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
2
answers
17
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 ...
- 1
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 ...
1
vote
0
answers
20
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 ...
- 11
1
vote
1
answer
66
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 ...
- 13
0
votes
1
answer
27
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. ...
- 3
1
vote
3
answers
126
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....
- 11
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 ...
- 71
1
vote
0
answers
33
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.
- 111
3
votes
1
answer
171
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 ...
- 31
2
votes
2
answers
66
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 ...
- 23
2
votes
4
answers
146
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 ...
- 121
4
votes
1
answer
287
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 ...
- 41
0
votes
2
answers
26k
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
...
- 391
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,...
- 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 ...
- 271