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

Sort by: Updated
3 answers

Mishandling of outer joins with column = value conditions

I understand that potential Access bugs can be reported here, and an MVP will pass them to Microsoft if they are validated. I'd be grateful if someone could do that with this one please. There is a problem in Access 365 editing certain outer join queries…

Microsoft 365 and Office | Access | Development
asked 2025-12-16T20:52:16.1666667+00:00
Nick North 0 Reputation points
commented 2025-12-18T18:03:51.2833333+00:00
Nick North 0 Reputation points
4 answers

accesing a remote table in access sql error 8000-4005

I using an excel macro to manipulate an access database, whith no change i start to get error 8000-4005, using an sql like SELECT * from [;DATABASE=C:\AdmData\Base\tempo.accdb;].tablename. microsolft support told me that in 64-bits access remote table…

Microsoft 365 and Office | Access | Development
asked 2025-12-15T18:41:33.93+00:00
Eduardo Fontana 0 Reputation points
edited a comment 2025-12-17T21:38:53.0566667+00:00
Tom van Stiphout 40,091 Reputation points MVP Volunteer Moderator
1 answer

How can I update to Office 365 Access Database Engine on a machine that has Office 365 already installed?

I develop an application that reads data from MS SQL Server and updates an MDB file I read that Office 2016 driver is no longer supported so I updated to Office 365 (…

Microsoft 365 and Office | Access | Development
asked 2025-12-11T23:12:27.8766667+00:00
Azali, Mark 0 Reputation points
commented 2025-12-17T02:24:08.3+00:00
TiNo-T 9,475 Reputation points Microsoft External Staff Moderator
4 answers

ACEOLEDB.DLL from Microsoft 365 Apps crash with Exception code 0xc0000005

ACEOLEDB.DLL from Microsoft 365 Apps (at least versions 16.0.14228.20248, 16.0.14430.20006, 16.0.14701.20040 in "C:\Program Files\Microsoft Office\root\VFS\ProgramFilesCommonX64\Microsoft Shared\OFFICE16\") appear to cause an application crash…

Developer technologies | C++
Developer technologies | C++
A high-level, general-purpose programming language, created as an extension of the C programming language, that has object-oriented, generic, and functional features in addition to facilities for low-level memory manipulation.
4,027 questions
Microsoft 365 and Office | Access | Development
asked 2021-12-29T20:18:30.603+00:00
Jmenninkainen 31 Reputation points
edited a comment 2025-12-13T07:26:55.2666667+00:00
David Lightstone 5 Reputation points
3 answers

GetObject WMI Bug in Access 2510 (Build 19328.20244)

Attempting to call GetObject("winmgmts://./root/cimv2") from the Form_Activate event handler when opening a form using a Hyperlink SubAddress fails with an automation error "Unspecified error". Opening/activating the same form using…

Microsoft 365 and Office | Access | Development
asked 2025-11-25T16:42:34.3433333+00:00
Scot L 5 Reputation points
commented 2025-12-10T20:45:52.3433333+00:00
DBG 11,531 Reputation points Volunteer Moderator
3 answers

Microsoft Access form controls not updating after table changes

In Microsoft Access where updates I make to the underlying table aren’t being reflected in my bound form controls. I’ve already tried refreshing the form, rebuilding the record source, and even recreating the form from scratch, but some fields still show…

Microsoft 365 and Office | Access | Development
asked 2025-12-05T09:37:32.4933333+00:00
Conley Evan 40 Reputation points
answered 2025-12-05T18:15:00.1433333+00:00
DBG 11,531 Reputation points Volunteer Moderator
1 answer

Search key was not found in any record Access 2016

weird Characters can not be deleted nor edited in access 2016

Microsoft 365 and Office | Access | Development
asked 2025-11-30T13:01:02.0133333+00:00
German Umali 0 Reputation points
commented 2025-11-30T16:29:36.23+00:00
George Hepworth 22,295 Reputation points Volunteer Moderator
2 answers

Update a year in a date field

hi i have a access db with a date field that hold data in the following format 02/10/2024 11:01:29 all i want to do is to be able on mass to update anything in the 24 year to 25, is there a way this could be done please? thanks in anticipation

Microsoft 365 and Office | Access | Development
asked 2025-11-30T07:23:52.4166667+00:00
Mark Powell 0 Reputation points
edited an answer 2025-11-30T14:33:12.6733333+00:00
Ken Sheridan 3,546 Reputation points
2 answers

Access Report Prints Form Instead — Seeking Insights from the Community

Hi everyone, I'm hoping someone here can shed light on a frustrating issue we've been facing with Microsoft Access. We have a database where users click a button on a form (labeled “Delivery Sheet”) to open a report in Print Preview mode. The report…

Microsoft 365 and Office | Access | Development
asked 2025-06-12T17:57:21.6633333+00:00
Phillip Bridgeman 0 Reputation points
edited an answer 2025-11-25T17:17:22.8166667+00:00
Ken Sheridan 3,546 Reputation points
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-24T13:14:14.4033333+00:00
Jack-Bu 5,495 Reputation points Microsoft External Staff Moderator
3 answers

Microsoft Access 2007 login button not working solution

How to create login form in Access 2007 step by step

Microsoft 365 and Office | Access | Development
asked 2025-11-19T14:24:29.4533333+00:00
Wisdom Chukwudalu 0 Reputation points
answered 2025-11-20T14:04:23.5733333+00:00
Ken Sheridan 3,546 Reputation points
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,995 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,546 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,495 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 8,675 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,546 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 | For business | Windows
Microsoft 365 and Office | Access | Development
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