Questions tagged [ms-access]

Microsoft Access is an application development and database development tool from Microsoft. It combines the Microsoft Jet/ACE Database Engine with a graphical user interface and software-development tools. Other database engines, such as SQL Server and MySQL, can also be used as a database server for Access applications.

Filter by
Sorted by
Tagged with
0 votes
0 answers
24 views

How to create a tag system on my Access database?

I work with Access in a very rudimentary way. I use it to store data about events that involves guests and our staff. The amount of people in total is enormous, so it is imposible to add the people in ...
Teusdu's user avatar
  • 101
0 votes
1 answer
25 views

Try to duplicate column= attribute1 at time=0 horizontally even on rows where time!=0 for every unique ID

Given a table such as this, I want to create a table via SQL without doing window functions id time attribute1 attribute1atFirstRecordedTimeperID 1 0 a a 1 2 b a 2 0 c c 2 4 d c I tried SELECT ...
Coo's user avatar
  • 101
1 vote
0 answers
41 views

How would I connect to a SQL Server (running in a VM using Ubuntu Server), using Access or Visual Studio on my host?

I have tried to connect various ways already and have not been successful. I need a more specific guide on how to/if you can connect this way. I have specific limitations that you need to account for, ...
Vividlee's user avatar
0 votes
1 answer
41 views

Is it possible to use ApplicationIntent with Microsoft Access

we host an MS SQL 2019 database using a read replica and were wondering if it is possible to use applicationintent=readonly in the Linked Table Manager connection string in MS Access to force it to ...
aprestonprpo's user avatar
0 votes
0 answers
113 views

MS SQL server runs slowly on new Linux server

I am running a relatively small Access application with an SQL server 2019 backend, and have recently updated my ~10+yr old Linux system that is running the server. I was surprised to find that SQL ...
D Lepp's user avatar
  • 1
0 votes
1 answer
196 views

Update the second last row for each group

I am building a database in SQL Azure, with an MS Access front end. I have a set of data in a table called PostHolders which looks like this: ID PersonID ApppointmentID ContractStartDate ...
Andrew Richards's user avatar
0 votes
1 answer
29 views

No longer able to re-order custom groups in Microsoft Access navigation pane

After not using Microsoft Access much for about 3 years, I discover I'm not able to drag & drop to re-order groups in the Navigation Pane while in 'Custom' view. What am I missing? Did they remove ...
spinjector's user avatar
0 votes
0 answers
34 views

How do I handle parameterisation for custom user filters?

I'm managing a MS Access application where one of the features is a list of projects with about 20 attribute columns. Most of these columns can be filtered individually. Naturally, this has led to ...
ApexPolenta's user avatar
-3 votes
2 answers
35 views

In Microsoft Access, how to make the first letters of a compound word, with or without hyphen(s), be automatically capitalised?

When the user enters "anna mae", it should turn to "Anna Mae", and "anna-mae" should turn to "Anna-Mae".
peanutjelly's user avatar
1 vote
0 answers
22 views

Check values from previous rows in data validation rules

How can I create a data validation rule for access table which will check the current value with the previous value? Take the following table as an example: Table: Meter Reading Date Value Remarks ...
Ahmed's user avatar
  • 111
0 votes
1 answer
152 views

Creating a one to many relationship in Microsoft Access

In Microsoft Access I have created two tables. For the first table, Access has created a primary key ID field that does not allow duplicates. For the second table, Access has created a primary key ID ...
Jimbo's user avatar
  • 65
0 votes
0 answers
17 views

Custom UI XML Error on only one computer?

I have a Microsoft Access database that throws errors upon logging in....but only on one person's computer. No one else in the same firm has the issue. It gives him the error: Custom UI Runtime Error ...
J.D. Walker's user avatar
1 vote
1 answer
50 views

QGIS ODBC connection to shared Access database only working when Access closed at QGIS start-up

I am working with an MS Access database which is located on a shared folder and regularly used by other users at the same time (the database is split into several user front-ends and a back-end). I ...
Matt B's user avatar
  • 11
1 vote
0 answers
61 views

How to add a calculated field to a Microsoft Access query that equals the minimum value of the previous column field

I have a simple query on a very complex query that reads: SELECT Query1.Rdate, Query1.Rank, Query1.Score FROM Query1; ...
HBHAYWOOD's user avatar
1 vote
1 answer
749 views

How to store decimal numbers in MS Access

I tried to store decimal number, but couldn't. It's Office 2019. I tried both number types, and different "format". One format had some zero's show up after a comma, but could not enter ...
Valter Ekholm's user avatar
0 votes
1 answer
28 views

How to print category tree in MS Access

I have a table for competences. I have made it like a parent-child relation, so there is for example driver-licence as a row, and car-driver-licence as another row, having 'driver-licence' as a parent....
Valter Ekholm's user avatar
0 votes
1 answer
66 views

Process for loading data into a logically-arranged Access database with many-to-many relationships

I'm struggling with the logic and feasibility of a certain workflow. I have a list in Excel containing DatabaseName, TableName, FieldName, SubtypeName, and DomainName. I'd like to select all of the ...
jdawgx's user avatar
  • 1
0 votes
0 answers
45 views

Automatically fix case usage in table and column names from Access to MariaDB

I am converting an existing MS Access application to use a MariaDB backend running on CentOS 7. I used a tool from BullZip to convert the Access database to MySQL. After that I used another tool to ...
Niek van der Steen's user avatar
0 votes
1 answer
81 views

In MS Access 2019, how do I find numbers in a lottery table that appear often together?

I have a table with 256 lottery drawings, pick 5, along with the drawing date. I want to know how many times my favorite numbers (4,7,47) or any numbers, came out at the same drawing. I am thinking ...
David Ochoa's user avatar
0 votes
2 answers
108 views

How to send an access database

I’m having trouble trying to find a way to send a ms access application to someone I have built one for. They say you cannot open it from OneDrive or problems occur. But is the person able to copy it ...
CShane13's user avatar
0 votes
0 answers
64 views

Migrate Access mde app and Microsoft Sql Database to another PC

I need to move an old Access app, which runs on a windows server 2003, to my Windows 10 PC, The app is run from the Server desktop via mde file and is connected to a microsoft SQLEXPRESS database ...
EricDrvn's user avatar
0 votes
1 answer
505 views

Data Type mismatch error when using function in SQL Statement

I have a function which gives Levenshtein Distance used for fuzzy search of a field. Option Compare Database ' Levenshtein3 tweaked for UTLIMATE speed and CORRECT results ' Solution based on Longs ' ...
Knightowl3128's user avatar
0 votes
0 answers
242 views

Create a student-grade query from a relational database

I have three tables: Students (Id, name) Assessments (id, name, max_score) StudentAssessment (Id, student_ID, assessment_id, score) where ids are FK from the other two tables. I think this is the most ...
MartynW's user avatar
  • 103
0 votes
1 answer
1k views

Access Search Form is not including null values

Sorry if this is an overly easy question, I don't use access often but was asked to make a search form for a table our company uses to track remake parts. I have a form created with a series of ...
DaringAardvark's user avatar
0 votes
1 answer
60 views

Select employees who have NOT completed all training

I'm not a frequent DBA, but I'm working on something to track training complete for some employees and I'm a bit stuck. I'm using MICROSOFT ACCESS and have 3 tables: Employees Last_Name (...
Cerkoryn's user avatar
0 votes
1 answer
369 views

Looking for file-based DB engine alternative to MS Access

My company has been chained to this MS Access '97 .MDB format we've had since the dawn of time. Our schema is hierarchical, with multiple one-to-many relationships. We are at a point where we are ...
Kate M's user avatar
  • 3
5 votes
3 answers
2k views

SQL Database vs Multiple Microsoft Access Databases

The company I work for produces a lot of test data in raw text files from lots of different devices. Each device belongs to a 'process' of which there are only a few dozen. Currently we have a program ...
Chris McQueen's user avatar
1 vote
0 answers
315 views

MS Access SQL - Left Join (or sub-query?) most recent related record

Hello Database Administrators. Thank you so much for your help with this issue. It blows my mind that something so simple can be so complicated. I have an MS Access database with two tables. The first ...
Mark D's user avatar
  • 11
1 vote
0 answers
62 views

Best Method for Modeling/Implementing Dependent Primary Child?

I’ve implemented Primary Child functionality using a third table as described by @ypercube here (and other posts). I chose this method because it’s database-agnostic, simple (no triggers or deferred ...
DoctorYes's user avatar
0 votes
1 answer
931 views

MS Access - How to sum matching criteria from two columns in same table

I have an MS Access database with four columns of interest that I am trying to work with. The rows represent sold jobs, and the columns of interest are "OriginalSaleAmount", "...
JDDellGuy's user avatar
0 votes
1 answer
2k views

Combine multiple rows into one single column (MS Access)

I am trying to build a query from a table (Tbl_XYZ) that will give me the information for the primary key all in one row rather then creating dups for that primary key and showing up with multiple ...
RayJ's user avatar
  • 1
1 vote
1 answer
895 views

SQL in Access to add leading 0 in front of zip codes

for a project I am working with a table of zip-codes that I imported from a *.csv file, exported form Excel. Those zipcodes all have 5 numbers and are formatted as text within my database. Some of ...
Titan's user avatar
  • 11
0 votes
1 answer
171 views

MS Access and multiple users

I'm looking for some help regarding Microsoft Access and database design. I have been developing a database application on Microsoft Access for use in my organisation. I work in a hospital and we have ...
slimn's user avatar
  • 3
0 votes
1 answer
184 views

Inputting same data on identical Field Name on different table

currently i am new in ms access, And currently - as a trial and learning step - I created Two tables, and a Single Form that can be used to put a value to both tables, those are: Table 1 - "...
Idad's user avatar
  • 1
0 votes
1 answer
403 views

VBA - Hide a Form tab depending on the value of a field

pretty simple question here in scope. Question: Wondering If I would be able to hide the tabs of a form based off the values of a table's fields. I have been reading the 2019 Access Bible and so far ...
Brandon G's user avatar
0 votes
1 answer
14 views

What kind of object is made when we make CREATE VIEW, and what sort of commands can be ran on it?

I would like to understand the difference between a table and a View in SQL (Ms Access, if it makes any difference). So I know Create View command can be used to "pull" all fields and ...
Sasha1001's user avatar
1 vote
0 answers
326 views

Select value and display in a combobox if the datetimepicker value lies between two extreme dates in a table in database

I am creating an attendance management system in vb.net and using MS access as my database. I created a leave form in which the student on leave has a roll number and his details along with the from ...
Vivek's user avatar
  • 11
0 votes
1 answer
52 views

Why does Access recalculate a stored query when I copy it? Can I tell it not to?

When I copy and paste a stored query in Access, it's usually because (a) I want to back up the code before making changes, or (b) I want to make a new query by making changes to that one. All I want ...
NewSites's user avatar
  • 111
-1 votes
2 answers
159 views

Database schema - Set Limit values in correlation to groups and/or it's members

Provided there are pre-existing tables (diagram attached below). They each have numerous use-case as far as potentially related attributes. Still, I am at a roadblock following best practices with ...
Marcin Koziel's user avatar
0 votes
1 answer
104 views

Compact Database VBA for an .mdb that utilizes a .mdw security file

The below code works great when you call an unsecured database from another database. But I am trying to compact an .mdb in Office 2013 that has user-level security (.mdw). If I try the below code ...
Mark's user avatar
  • 1
0 votes
0 answers
24 views

How do you modify query to include additional fields in the results?

I have the following MS Access query: SELECT * FROM (SELECT [cnPart],[desc] as DATA,"desc" as CAT from PartData UNION SELECT [cnPart], [qty], "qty" FROM PartData UNION SELECT [...
Monika's user avatar
  • 1
1 vote
1 answer
786 views

Find Max Date from a Distinct Row Then Add Value to a Table Column

Quick disclaimer - I am familiar with Access, but a novice at MySql within Access. I have a table with activity data that I pulled into a query to filter down to only necessary data. The query table ...
Andres Martinez's user avatar
1 vote
2 answers
59 views

Return results with several LIKE and NOT LIKE requirements

I am trying to create a query that selects only a set of values, but excludes other ones. The column I am selecting it's called "Participants" and the values therein are not a single text ...
Geo_explorer's user avatar
0 votes
1 answer
233 views

How to Stop MS Access From Undesired Cascading Delete? [closed]

When I delete a record from one Microsoft Access table, it deletes the corresponding record in another table. I need to stop that. Table 'items' has ID (the key), item_name, and some other fields. ...
Kevin Kleinfelter's user avatar
0 votes
1 answer
136 views

Q: Updating multi table linked view with MS Access

I have an MS Access db with a linked table pointing to an MS SQL server database view. We have been using MS Access as a simple front end to change data contents via this view. The view was ...
Tamás Vándorffy's user avatar
0 votes
1 answer
598 views

Expressing A Composite Key in a Data Dictionary

I am looking for an example of expressing a "Composite Keys" in a data dictionary. I am using an MSO Access application with a Lecturer Table and Subjects Table where I have taken the ...
Jeff's user avatar
  • 1
1 vote
1 answer
163 views

How to design a query to pop up input with two text boxes in MS Access

I ask this question while I could not find any similar question neither on Google nor DBA Stackexchange, this question might be duplicated. I wrote this query in MS access to check for first name and ...
Mr JJ's user avatar
  • 11
0 votes
1 answer
48 views

Consolidate / sort / combine / merge data for dummies

I am looking for a non-scripting solution to combine data from 3 different tables (preferably using spreadsheet software like Microsoft Excel but a database would also work e.g. Microsoft Access). I ...
Ad Astm's user avatar
  • 103
0 votes
0 answers
22 views

how to Manipulate duplicated records using access

Using Microsoft Access, I have a number of records that have duplicated field-1. I need to form a query such that the duplicate records get unique ; BUT the next filed-2 data must be seen in columns ...
user4549384's user avatar
1 vote
1 answer
313 views

3 Simple Queries SQL Student Question, Query Errors in Microsoft Access

The First Question is: "List the name of each trip that does not start in New Hampshire (NH)." SELECT TripName FROM Trip WHERE State!='NH'; /* works with State='NH' */ The Second Question ...
rubengavidia0x's user avatar

1
2 3 4 5
14