925 questions with Microsoft 365 and Office | Access | Development tags

Sort by: Updated
2 answers

Ms access reading data from c# code is giving unspecified error

Hi team, Facing issue while reading data from ms access in one of our widows service. after restarting the vm , the issue is getting resolved. Thank you

Microsoft 365 and Office | Access | Development
asked 2025-11-11T08:59:13.3966667+00:00
Dasu, Siva (Dasu,Siva) 0 Reputation points
commented 2025-11-14T08:26:43.2+00:00
Michelle-N 7,865 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

How to sum column C and D if columns A = Starmer and B = Elected.

I have the following table. I need a way to a) aggregate elected position for each name b) aggregate non-elected position where it does not match the name c) a total of each one So for example Starmer wins. The Elected result should show 38. Non-Elected…

Microsoft 365 and Office | Access | Development
asked 2025-11-11T20:43:23.74+00:00
HelloWorldMan 20 Reputation points
commented 2025-11-13T08:25:34.7166667+00:00
Austin-H 6,640 Reputation points Microsoft External Staff Moderator
2 answers

How-to get RichText from LongText AppendOnly ColumnHistory()?

Is there a workaround to get the HTML-ish RFT from ColumnHistory() of a LongText field set with RichText format and AppendOnly versioning? I'm not trying to defend AppendOnly vs better solutions. Or storing HTML-ish RTF in Access. Just asking if anybody…

Microsoft 365 and Office | Access | Development
asked 2025-07-25T22:26:34.42+00:00
Dick Watson 126 Reputation points
commented 2025-11-13T06:46:49.1833333+00:00
Dick Watson 126 Reputation points
4 answers One of the answers was accepted by the question author.

Update Table Column with Sum of Two Numbers in Two Tables

I have ran into a brick wall trying to create an update query. I want to update the number stored in the column of a table with the sum of another number in the same table and another number in another table. Attached is the relationship between the…

Microsoft 365 and Office | Access | Development
asked 2025-11-07T16:18:05.6666667+00:00
Keith A 40 Reputation points
edited a comment 2025-11-11T14:31:03.1233333+00:00
Ken Sheridan 3,381 Reputation points
3 answers

Error in InStrRev with respect to VarType

The MS ACCES has problems with this statement:  HAVING     (((                 1 * InStrRev ([Query21].[Naam tegenrekening], "Broek")) = 13 )) It reports "Type Mismatch", yet VARTYPE on this expression reports type = 3 (long…

Microsoft 365 and Office | Access | Development
asked 2025-11-07T10:39:28.52+00:00
Pieter van Leeuwen 0 Reputation points
commented 2025-11-10T06:11:57.81+00:00
Jack-Bu 5,310 Reputation points Microsoft External Staff Moderator
1 answer

My MS Access can connect to Azure Synapse SQL Serverless Pool, but failed to obtain data.

I connect from local MS Access File to Azure Synapse SQL Serverless Pool. I can connect to the db, and select the table and its column, but failed after select the column and got the error above. And another error message said the process is occupied by…

Microsoft 365 and Office | Access | Development
asked 2025-10-31T04:54:56.94+00:00
Jason Wong 20 Reputation points
commented 2025-11-05T06:50:38.6833333+00:00
Dora-T 7,705 Reputation points Microsoft External Staff Moderator
2 answers

Query to copy distinct records - no duplicates

I need to create a query to copy ONLY DISTINCT records to a new table where the old table has many duplicates? Should I set the query to copy only the First of each field? Also how do I insure that the new table accepts only distinct re records going…

Microsoft 365 and Office | Access | Development
asked 2025-10-26T18:24:17.45+00:00
Maxine Nietz 1 Reputation point
answered 2025-10-27T13:01:43.0933333+00:00
Ken Sheridan 3,381 Reputation points
1 answer

Microsoft Access Database Engine(ACE OLE DB 12.0)

How can I download Microsoft Access Database Engine(ACE OLE DB 12.0)? And how can I equip it with my visual Studio 2022?

Microsoft 365 and Office | Access | Development
asked 2025-07-04T01:27:22.48+00:00
Mojito 5 Reputation points
commented 2025-10-26T04:01:26.11+00:00
vini Rayal 0 Reputation points
2 answers

Can I change Azure SQL Server port 1433 to a different port (Connecting externally using MS Access ODBC)

Hi, Our IT has flagged port 1433 as being high risk and has requested that we change the way we connect our Access DB to our Azure SQL server. Currently we are connecting using the standard ODBC connection string. Any ideas or information would be…

Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | For business | Windows
asked 2024-05-16T05:19:08.68+00:00
T West 136 Reputation points
commented 2025-10-19T07:03:28.5466667+00:00
Gustav 722 Reputation points MVP
2 answers

Setting TabIndex Property in VBA No Longer Working After Recent MS Office Updates

September: After my PC installed recent MS Office updates (within the last two weeks), currently running Version 2508 Build 16.0.19127.20192 (32-bit), setting the TabIndex property is no longer behaving as expected. I have procedures, in MS Access forms,…

Microsoft 365 and Office | Access | Development
asked 2025-10-03T17:54:13.63+00:00
Eric Yevtushok 0 Reputation points
commented 2025-10-08T18:54:48.1033333+00:00
Eric Yevtushok 0 Reputation points
4 answers

How to I get my Office 2019 back. 365 has replaced it.

I own MS Office Pro 2019. 365 has now replaced it. I want 2019 back. How this happened: I volunteer with a non-profit that uses 365. In order to coordinate calendar, they gave me a 365 email account. When I activated the 365 email in 2019…

Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Install, redeem, activate | For business | Windows
asked 2022-10-24T12:40:54.73+00:00
Coach Pop 6 Reputation points
edited a comment 2025-09-28T16:55:11.25+00:00
Stefan Blom 320.1K Reputation points MVP Volunteer Moderator
1 answer One of the answers was accepted by the question author.

How to fix Automation error Object is not connected to server

I have an MS Access database with a table that has an OLE Object type field. The field stores a PowerPoint slide associated with the rest of the data in the record. I have a form with a bound object frame for the OLE Object field. There is a Button on…

Microsoft 365 and Office | Access | Development
asked 2024-12-02T17:17:17.8866667+00:00
William Sessums 20 Reputation points
accepted 2025-09-26T19:48:15.8733333+00:00
William Sessums 20 Reputation points
3 answers One of the answers was accepted by the question author.

Access declare stmt issue moving from Windows 10 to 11

Hi, I have a basic Access database that is erroring on me now that it was updated to Windows 11. The error message is Compile Error The code in this project must be updated for use on 64-bit systems. Please review and update Declare statements and then…

Microsoft 365 and Office | Access | Development
asked 2025-09-24T22:44:15.5566667+00:00
Eileen T 40 Reputation points
answered 2025-09-24T23:35:54.47+00:00
Eileen T 40 Reputation points
7 answers One of the answers was accepted by the question author.

TransferDatabase help

I have a MS Database that when I close the database, I want to export the main data table to a back-up database. Here is my VBA script - destfilename = "PGA Matrix 6-2022 - REP VERSION.mdb" destfileloc =…

Microsoft 365 and Office | Access | Development
Developer technologies | Visual Basic for Applications
asked 2022-06-13T19:33:04.44+00:00
Michael Moore 21 Reputation points
commented 2025-09-12T11:25:04.5566667+00:00
Moore, Mike [EMR/MSOL/HSTN] 0 Reputation points
4 answers One of the answers was accepted by the question author.

Eorris when Using Chinese characters in sql queries in ACCESS Database.

Hi, from June, the access sql will pop up error as below, when referencing any Chinese character as the screen shot. The exact same codes worked well in May.

Microsoft 365 and Office | Access | Development
asked 2025-06-16T01:40:35.5666667+00:00
Xiaoyu Wang 20 Reputation points
commented 2025-09-03T06:31:08.22+00:00
Dora-T 7,705 Reputation points Microsoft External Staff Moderator
2 answers

Microsoft Access Database Engine 2016 Redistributable (64-bit)

Microsoft Access Database Engine 2016 Redistributable (64-bit) have end of life in the end of October 2025 and it not have windows server 2016 support : Supported Operating Systems Windows 10, Windows Server 2012 R2, Windows Server 2008 R2, Windows…

Microsoft 365 and Office | Access | Development
asked 2025-08-24T12:56:54.8+00:00
רומן פרייץ 0 Reputation points
commented 2025-08-29T01:35:11.13+00:00
Teddie-D 7,715 Reputation points Microsoft External Staff Moderator
3 answers

Import named TABLES (not RANGES) from Excel to Access

So I've referenced this issue several years ago access-2016-import-from-excel-2016-table-names-do-not-show-up) I have not been able to Google anything new on this topic so I thought I'd try to bring it up again to see if there is any new information.…

Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Excel | For business | Windows
asked 2022-11-09T18:43:39.953+00:00
Dom 951 Reputation points
commented 2025-08-28T13:44:50.3366667+00:00
George Hepworth 22,130 Reputation points Volunteer Moderator
3 answers

Microsoft Access - My report is only showing up as a half page vertical

Every time I go to run my report, it shows up as a half page vertical. Can anyone provide me with step by step instructions on how to correct this? I cannot figure out how to get the report to show up and save as a full page.

Microsoft 365 and Office | Access | Development
asked 2025-06-06T13:00:51.8333333+00:00
JM2025 0 Reputation points
commented 2025-08-12T14:03:01.5166667+00:00
George Hepworth 22,130 Reputation points Volunteer Moderator
2 answers

Link MS Access to Visual Studio Code with Custom made plug in

Hello, I'm exploring the possibilities of connecting MS Access , the VBA backend of the application , with VS Code. The intention would be to create modules, classes and use existing form controls from within the MS Access application in VS Code. My…

Microsoft 365 and Office | Access | Development
asked 2022-02-16T22:18:41.207+00:00
Mathias Z 1 Reputation point
commented 2025-08-12T11:37:56.0533333+00:00
Seedback 0 Reputation points
3 answers

In MSAccess 2003, how to fix the "Not responding" file open, import or link window.

On a new computer with a clean Windows 11 installation. When using MSAccess 2003 (can't confirm for Excel or Word) and trying to open anything related to the file explorer (File - Open, Save as, New, import and link), the small file explorer window hangs…

Microsoft 365 and Office | Access | Development
asked 2025-08-01T02:08:57.5233333+00:00
FD-5007 0 Reputation points
answered 2025-08-01T12:18:01.2466667+00:00
George Hepworth 22,130 Reputation points Volunteer Moderator