57,839 questions
Score of 1
1 answer
63 views
MS Access re-uses already established ODBC connections, disregarding differing connection parameters
MS Access seems to re-use already established ODBC connections, disregarding differing connection parameters, when using multiple Linked Tables.
I suspect this happens with EVERY kind of database ...
- reputation score 882
Score of 0
2 answers
108 views
A query with a field that counts the number of fields > 0
I created a query with fields containing values (quantities of items in different warehouses) from the table named TABELLA.
The query checks the "Check_ID" field of the "TABELLA" ...
- reputation score 423
Score of 1
2 answers
135 views
Create a query with columns containing sums of values from a table
I have a table with 3 columns:
Part Number
Location (where the part number is stored - 4 cities "London, Paris, Rome, New York")
Quantity (how many products are stored in that location)
I ...
- reputation score 423
Score of 0
1 answer
152 views
Problem opening Access database requires a newer version of Microsoft Access
I have the following environment:
Windows 11, version 25H2
Microsoft® Access® for Microsoft 365 MSO (Version 2606 Build 16.0.20131.20154) 64-bit
Microsoft Access Database Engine 2016 Redistributable (...
- reputation score 1094
Score of 0
1 answer
143 views
SUM(amount) not working when also calling base column amount in SELECT clause
I want to create a query that shows the amount of an item kept at a specific location, but also the total combined amount of every location that has that item.
For example; if location 1 has 400 of a ...
- reputation score 91
Score of 3
0 answers
157 views
Bulk insert into Access DB from a large CSV file takes a lot longer using OLEDB than the old ADO. Any way to speed it up?
I have a legacy app that was written in VBA running within Access. A mathematical model produces CSV files with millions of rows. The VBA code then bulk inserts these into an Access table (with no ...
- reputation score 43
Score of 1
3 answers
122 views
Can I override Microsoft Access display default of four digits instead of two digits for calculated dates less than 50?
For reporting purposes, I need to give the date of an individual's death and how old they were on that date. To make my life easier, I have set up a calculation in Microsoft Access 2019 to display a ...
- reputation score 11
Score of 0
2 answers
217 views
Previously working database access code in Visual Basic 26 program suddenly throws exception
I have a fairly complex VB program that accesses various components of my home control and monitoring system and displays data from them on a form on my desktop. On startup, it downloads recent data ...
- reputation score 45
Score of 0
1 answer
82 views
MS-ACCESS: In SUBform list records grouped by MAINform-ID
I have a MAINform with ID and a SUBform linked using this ID. In the SUB actually I have a textfield [Funktion] with f.e.
A: Gymnastics
B: Running
C: Climbing
Now I'd like to to change this into a ...
- reputation score 501
Score of 0
0 answers
111 views
ODBC Microsoft Access Driver Not a valid password. (-1905)
I'm trying to open a Jet Access database file with pyodbc but I'm getting this error :
ProgrammingError('42000', "[42000] [Microsoft][ODBC Microsoft Access Driver] Not a valid password. (-1905) (...
- reputation score 381
Score of 1
2 answers
259 views
The right square bracket within a charlist in the LIKE statement in Microsoft Access
The right square bracket can't be enclosed within the square brackets and thus can't be used also within a charlist, for example:
Like "*[#?]]*"
Is any other way to to insert the right ...
- reputation score 105
Score of 0
5 answers
180 views
Query to select a value of a column of a table identified by a value of another table
I'm wondering if it is possible to use an Access SQL query that selects a value of a column of a table identified by a value of another table.
For example I have tables A, B, C and D:
A:
ID_A
tbl
...
- reputation score 27
Score of 0
1 answer
82 views
Access DB query can't rename column to "Supplier", column shows up blank
I'm having an issue with the following query:
SELECT
[ON1].EarliestDate,
[ON1].Route,
"***" AS Carrier,
[ON1].Supl, <--- This is the problem column
[ON1].Seq,
...
- reputation score 21
Advice
0
votes
4
replies
93
views
Basic timesheet program: add a timestamp and the time completed in a sheet with ID and automatically linked name and date/time
I am creating a basic timesheet for my job using Microsoft Access. We have ID cards that have our specific ID number. I am trying to figure out a way to swipe the card (we already have a card reader).
...
- reputation score 1
Score of 2
2 answers
80 views
Access query for finding whether participants in a program returned in the next season
I'm not really sure how to start formulating the query that I want to run.
I have participants (tblParticipants) who attend programs (tblPrograms) that take place in a year and season (e.g., Spring ...
- reputation score 39
