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

Sort by: Updated
2 answers One of the answers was accepted by the question author.

Access App which Front-end intermittently fails to connect to shared back-end database

分割構成の Microsoft Access アプリ(各端末に ACCDE フロントエンド、ネットワーク共有に ACCDB バックエンド)を使用しています。一部のユーザーで「ファイルが使用中のため開けない」エラーや、フォーム表示の遅延・接続切断が断続的に発生します。 権限や構成に変更はなく、複数ユーザー同時利用時やネットワーク不安定時に発生しやすい状況です。 このような バックエンドのロックや接続不安定 をどのように切り分け・対処すべきでしょうか。

Microsoft 365 and Office | Access | Development
asked 2026-01-20T09:59:52.27+00:00
Akyo Kamashita 60 Reputation points
commented 2026-01-21T09:48:06.8133333+00:00
Dora-T 9,160 Reputation points Microsoft External Staff Moderator
1 answer

How to disable "tell me what you want to do" security flaw

How do I disable "tell me what you want to do" , it's a security flaw! I'm a small business , we work with charities. I have just discovered this flaw ( I know its been there for years but i never knew what it could do! ) which bypasses all…

Microsoft 365 and Office | Access | Development
asked 2026-01-21T02:09:32.64+00:00
Cory Belfon 0 Reputation points
edited a comment 2026-01-21T08:47:11.9033333+00:00
Viorel 126.1K Reputation points
2 answers

Monaco editor is messing up Pass-through queries

I have documented some issues with the Monaco editor in the video linked below.  I'm hoping to get the attention of the Access team. The editor should not format the SQL of pass-through queries without consent.  The formatter is adding carriage…

Microsoft 365 and Office | Access | Development
asked 2026-01-07T06:52:45.1633333+00:00
Sacherich, Ben 0 Reputation points
commented 2026-01-14T14:33:28.56+00:00
Flora-T 9,445 Reputation points Microsoft External Staff Moderator
4 answers

i have a microsoft access for ,32 bit, need to update to 64 bit. i have added PtrSafe to the Declare statements , now the form will not open

i have a microsoft access form ,32 bit, need to update to 64 bit. i have added PtrSafe to the Declare statements , now the form will not open

Microsoft 365 and Office | Access | Development
asked 2026-01-09T12:35:22.15+00:00
McLeod, Barry 0 Reputation points
commented 2026-01-12T18:54:41.97+00:00
Hani-Ng 7,000 Reputation points Microsoft External Staff Moderator
9 answers

IIF Function broken in Expression Builder for MS Access 2016 MSO 365

I have the same issue as mentioned here : https://learn.microsoft.com/en-us/answers/questions/4918053/iif-function-broken-in-expression-builder-for-ms-a Only my regional settings are okay, so I don't have the dot. issue but I can't make any IIf function…

Microsoft 365 and Office | Access | Development
asked 2026-01-07T15:32:48.5933333+00:00
P Lenarts 0 Reputation points
answered 2026-01-08T11:50:53.84+00:00
P Lenarts 0 Reputation points
1 answer One of the answers was accepted by the question author.

Question dans access

Dans un formulaire access je veux introduire un nombre dans un champ non lié

Microsoft 365 and Office | Access | Development
asked 2026-01-04T16:56:34.9466667+00:00
Marc Rigaux 20 Reputation points
edited a comment 2026-01-05T12:01:53.3033333+00:00
Karl Donaubauer 2,861 Reputation points MVP
2 answers One of the answers was accepted by the question author.

How do I get Microsoft Access to quit blocking macros?

Access is stopping the macros I wrote under a different version and will no longer execute the macros.

Microsoft 365 and Office | Access | Development
asked 2025-12-27T23:19:33.77+00:00
Billy Woods 20 Reputation points
commented 2025-12-31T06:02:37.5566667+00:00
Dora-T 9,160 Reputation points Microsoft External Staff Moderator
2 answers

how to convert access 97 database to access 365

No tool provided by Microsoft to convert old databases created in Access 97, 2000 to current version of Access. Access 365 not opening databases created in Access 97 or 2000. Is this kind of support Microsoft providing to existing customer ? We are…

Microsoft 365 and Office | Access | Development
asked 2025-12-29T10:14:22.1933333+00:00
Manoj Jain 0 Reputation points
answered 2025-12-29T12:02:27.0033333+00:00
George Hepworth 22,400 Reputation points Volunteer Moderator
2 answers One of the answers was accepted by the question author.

How to make "Search As You Type" in MS Access continuous form

Hello everyone, I have this code which filters records in continuous form of MS Access when the user is typing, but the issue is that it does not accept the "Balck Space", meaning when I am trying to add "Space" it's removed…

Microsoft 365 and Office | Access | Development
asked 2025-12-22T07:39:40.25+00:00
Rohullah Sharifi 20 Reputation points
commented 2025-12-22T10:23:56.07+00:00
Gabriel-N 11,665 Reputation points Microsoft External Staff Moderator
7 answers One of the answers was accepted by the question author.

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 20 Reputation points
answered 2025-12-20T00:07:05.0333333+00:00
Tom van Stiphout 40,181 Reputation points MVP Volunteer Moderator
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
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 10,545 Reputation points Microsoft External Staff Moderator
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 80 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,400 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,566 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,566 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,745 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,566 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 7,495 Reputation points Microsoft External Staff Moderator