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.
680
questions
0
votes
0
answers
11
views
Microsoft Access (2007-2016) - Form List Box Can't Be Found In Current Record?
I'm currently using Microsoft Access file format "Access 2007 - 2016".
What I'm trying to do is make a form with a combo box, that when a value is selected will populate a list box with ...
1
vote
0
answers
33
views
PostGres DB is read only in pgAdmin despite successful migration into it
I have an old MS Access Database that I want to migrate to a Postgres Db hosted in a Docker environment on a Windows Server.
I want to keep the MS Access Frontend, because it has some Forms and ...
0
votes
0
answers
29
views
How to create table that logs old and new value
Consider the table "Names":
ID
Name
1
Paul
2
Tom
3
John
I would like to have a table "archive" that archives the changes that have been entered through a form in the following ...
0
votes
0
answers
26
views
"A potentially dangerous macro has been blocked"
There's an .ACCDB that's been used for years by a bunch of people. It's been inspected for macros, it has no macros in it.
When the file is opened MS ACCESS flashes this ominous warning:
After ...
0
votes
0
answers
17
views
How to mark a calculated query column as total:sum in Microsoft Access?
How can I ensure for Design View that the "total" line of this calculated column shows "sum"?
It seems to change after running the query and saving it.
What starts as:
TotalRevenue:...
0
votes
0
answers
33
views
How is the ! used in Microsoft Access queries?
The "bang" or exclamation point is a logical operator.
Just to follow up on a previous question, is it problematic to use "!" with Microsoft Access queries to specify tables and ...
0
votes
0
answers
37
views
How to remove a border or box surrounding a text box from a Microsoft Access report?
After adding a "Country" label and textbox to the underlying query, and then to the report, the "Country" label has a box around it. I cannot find the control to remove this box.
...
0
votes
0
answers
21
views
I need help pulling info from a .txt file into a table in either access or excel
So.. I've tried both Excel and Access to do what I need but I don't know the programs well enough to get them to do what I want, if it's even possible.
I have a hourly updating .txt file with ...
0
votes
1
answer
40
views
odbc--call failed. [Microsoft][ODBC SQL Server Driver][SQL Server]A collation conflict ... in the UNION ALL operator ... cannot be resolved. (#451)
I union all the distinct columns of the INFORMATION_SCHEMA.COLUMNS views of many databases which I query with a direct query:
select TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME from xyz
...
0
votes
0
answers
44
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 ...
0
votes
1
answer
26
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
...
1
vote
0
answers
48
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, ...
0
votes
1
answer
56
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 ...
0
votes
0
answers
178
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 ...
0
votes
1
answer
372
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
...