57,869 questions
0
votes
0
answers
69
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) (...
- 381
1
vote
2
answers
233
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 ...
- 105
0
votes
5
answers
164
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
...
- 27
0
votes
1
answer
75
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,
...
- 21
Advice
0
votes
4
replies
79
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).
...
2
votes
2
answers
72
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 ...
0
votes
2
answers
120
views
Impossible to connect to a Microsoft Access database in LibreOffice 25.2 with UCanAccess and jdbcDriverOOo 1.6.2
I need to edit the content of a MDB file under Debian Linux 12 with LibreOffice 25.2.
I tried to use the solution mentioned in the documentation (relying on UCanAccess) without success: I added the ...
- 4,294
1
vote
1
answer
83
views
MS Access VBA, Call Function, but goto a specific line of function
I'm using the code below to convert a pdf to Excel.
When the code gets to 'laptop version, it will open a form which I will execute things (haven't put that in the code yet).
On that form I'd like to ...
- 23
2
votes
3
answers
117
views
Equipment inventory tracking - filter out duplicates resulting from equipment marked 'vacant', or best way to mark equipment vacant
I have an Access database that is tracking trucks. I have one table for trucks and all their details, and another table tracking the drivers and their details. The third table is tracking positions ...
- 31
3
votes
2
answers
239
views
Migration from Windows 10 to 11 and VBA can no longer execute batch files or tasks
I have VBA running on MS 365 on a Windows 10 VDI. My VBA code includes executing a batch file which in turn runs some python code. This has all worked fine
I now have a Windows 11 physical PC, but ...
- 105
0
votes
1
answer
154
views
Update MS Access db with SQL that includes select statement
I'm using NodeJS and node-adodb to try to run an update on a MS Access database that includes selects. I tried this:
update [Objects]
set
[Object] = 1,
[CardID] = (select id from Oracle where ...
- 3,298
Best practices
0
votes
7
replies
74
views
Simultaneous access to a table in a shared folder
In the company I work for we have an Excel file that we need to fill out daily, stored in a network folder on the server.
Unfortunately, it can only be used by one user at a time.
I tried creating a ...
- 395
Advice
0
votes
5
replies
73
views
Modifying an Access VBA project with VBA
In principle I should be able to write some VBA code, and run it over a VBA project to amend the project.
Scenario: A collection of databases is being moved from one server to another.
There are a lot ...
- 61
4
votes
2
answers
166
views
VBA Err not reset after Exit Sub, despite documentation
VBA in Microsoft Access 365. According to Microsoft's documentation for Err.Clear,
Use Clear to explicitly clear the Err object after an error has been handled, for example, when you use deferred ...
- 1,464
1
vote
1
answer
141
views
Can't insert into Access database
I have an Access database (.mdb) that was created and sent to me by someone else. I have tried running it in both nodejs with node-adodb and with python and pyodbc, and I get an error. Here is my ...
- 3,298
