Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
954 questions
954 questions with Microsoft 365 and Office | Access | Development tags
3 answers
Microsoft Access: Database is in an inconsistent state on Network Shares
We have a split .accdb database stored on a shared network drive. Since the latest Office update, users are constantly getting the error 'Microsoft Access has detected that this database is in an inconsistent state.' Running 'Compact and Repair' dozens…
Microsoft 365 and Office | Access | Development
asked 2026-04-17T01:17:48.3166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 27%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3END%3C/text%3E%3C/svg%3E)
Nichols Dylan
40
Reputation points
commented 2026-04-20T00:29:55.3266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 1%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDT%3C/text%3E%3C/svg%3E)
Dora-T
12,500
Reputation points Microsoft External Staff
Moderator
3 answers
OleDbConnection using Microsoft.ACE.OLEDB.16.0 causes an access violation in mso98win32client.dll on app closing
I recently updated one of our VB.NET 4.8 applications from 32 bit to 64 bit. The application uses an OleDbConnection using Microsoft.ACE.OLEDB.16.0 to connect to an access database. We noticed that when the application closes, it hangs for around 15 - 20…
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
954 questions
asked 2026-04-02T11:00:59.9533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 33%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJR%3C/text%3E%3C/svg%3E)
Jonathan Riley
10
Reputation points
commented 2026-04-10T07:12:13.9+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 54%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
Steven-N
24,525
Reputation points Microsoft External Staff
Moderator
2 answers
MS Access ohe add in
seit gestern kann ich keine Email aus Outlook in MS Access 365 importieren, es sind keine Add ins vorhanden, ich kann auch keine nach installieren
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
954 questions
asked 2026-03-31T20:35:20.3133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 74%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIE%3C/text%3E%3C/svg%3E)
Ibrahim Etier
0
Reputation points
commented 2026-04-01T23:13:10.08+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 68%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHC%3C/text%3E%3C/svg%3E)
Hendrix-C
14,650
Reputation points Microsoft External Staff
Moderator
2 answers
Look/Style
How do I change the look/style of the overall database?
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
954 questions
asked 2026-03-30T15:00:44.8533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 28.999999999999996%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKP%3C/text%3E%3C/svg%3E)
Kimberlene Perry
0
Reputation points
commented 2026-03-30T16:57:25.7+00:00
George Hepworth
22,680
Reputation points
Volunteer Moderator
2 answers
I want to purchase time with an Access/Word merge specialist
I have a Access database that has a button that opens a DocumentMenu that is on a networked drive. That Menu hyperlinks to documents that, when clicked, are supposed to (and did, in Office2007) open forms that are connected to tables in my Access…
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
954 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 36%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDL%3C/text%3E%3C/svg%3E)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 25%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGN%3C/text%3E%3C/svg%3E)
2 answers
MS Access macro grouping
I have created a group block of actions within a Macro but cannot find how to remove the grouping specification.
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
954 questions
asked 2026-03-12T02:28:19.1066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 24%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMW%3C/text%3E%3C/svg%3E)
Mark Woodhead
0
Reputation points
commented 2026-03-16T03:03:23.5+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 64%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFT%3C/text%3E%3C/svg%3E)
Flora-T
11,775
Reputation points Microsoft External Staff
Moderator
4 answers
One of the answers was accepted by the question author.
Table entering a record with no data from form button click
I have a relational database table (itemTable) connected to a Main Form. Connected to the main form is a sub Form (itemImages)Connected to ItemImageTable . After Adding the item data, i go to enter the item images on the sub form but, after adding the…
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
954 questions
asked 2026-03-11T21:34:33.66+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 54%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Mark Truett
20
Reputation points
commented 2026-03-12T20:08:31.38+00:00
DBG
11,711
Reputation points
Volunteer Moderator
3 answers
One of the answers was accepted by the question author.
I want to ask is there a known registry override to increase the handle limit
My Access application is frequently crashing with Error 3048 ("Cannot open any more databases") despite properly closing all recordsets and setting objects to Nothing in my VBA cleanup routines. Since the latest Office update (Build 2602), the…
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
954 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 20%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHY%3C/text%3E%3C/svg%3E)
1 answer
Necesitamos SQLServer2005_BC_x64.msi para Access
Necesitamos SQLServer2005_BC_x64.msi, donde lo podemos decargar?. Aqui ya no esta https://archive.org/download/sql-server-2005-backward-compatibility-components/SQLServer2005_BC_x64.msi Es para usar un Access Gracias
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
954 questions
asked 2026-03-06T14:50:39.4166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 45%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFA%3C/text%3E%3C/svg%3E)
FranciscoJose.Aguilar
0
Reputation points
answered 2026-03-06T15:19:22.3966667+00:00
George Hepworth
22,680
Reputation points
Volunteer Moderator
4 answers
One of the answers was accepted by the question author.
ActiveX Register
Just upgraded to latest Access. How do I "Register" an ActiveX Control from a previous version?
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
954 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 70%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
3 answers
Why did DoCmd.TransferSpreadsheet acImport stop working intermittently?
After MS Office updates in October, DoCmd.TransferSpreadsheet acImport sort of stopped working for one of my 7 files. If I import that file first it works fine, but then I have to close the database and then reopen it to get the other 6 files to import.…
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
954 questions
asked 2026-02-10T21:32:58.0466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 84%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKB%3C/text%3E%3C/svg%3E)
Kristy Board
0
Reputation points
recommended 2026-03-02T09:43:32.3633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 77%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVP%3C/text%3E%3C/svg%3E)
Valeria Putuntica (BLUEHAWK LLC)
0
Reputation points Microsoft External Staff
Moderator
3 answers
How can I remove the extra files?
I am trying to create a form out of a query and a search form which gathers the inputs from the user. The three inputs are Start Date, SO #, and Job. In this example I only inserted 11/06/2025 for Start Date. It resulted in 7 records which is correct,…
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
954 questions
asked 2026-02-23T16:12:36.9033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 15%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELA%3C/text%3E%3C/svg%3E)
Lopez, Ahiezer
236
Reputation points
edited an answer 2026-02-24T22:50:43.7266667+00:00
George Hepworth
22,680
Reputation points
Volunteer Moderator
1 answer
MS Excel Power Pivot connection issue with MS Access Odbc
Hi There, I'm encountering problem Excel pivot refresh data failed when I was trying to pull data fm MS access. below if the errors appearing. can you pls help. desperately need help to problem fix. "[Microsoft][odbc Microsoft access…
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
954 questions
asked 2026-02-02T14:28:51.0833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 33%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
Ai Tee Ling (SG)
5
Reputation points
answered 2026-02-02T16:26:16.34+00:00
Karl Donaubauer
2,951
Reputation points MVP
4 answers
One of the answers was accepted by the question author.
Output Report to PDF Quit Working; Worked for Years Until Now (Microsoft Access)
I have an Access application that contains a command button to output a report to PDF. It has worked for 4-5 years and suddenly it no longer works. I get a message that says "Formatting page... press CTRL/BRK to stop". That continues until…
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
954 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 7.000000000000001%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
3 answers
One of the answers was accepted by the question author.
webbrowser control access vba
i have several access databases that use a webbrowser control to view pdf-files on the desktop. This worked fine for years , all of a sudden this doesn't work anymore. i get no error , but the webbrowser control is totally gray. what can be the reason…
Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
954 questions
asked 2026-01-21T18:46:32.1633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 12%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGD%3C/text%3E%3C/svg%3E)
Griet De Groote
20
Reputation points
commented 2026-01-27T14:45:21.1633333+00:00
George Hepworth
22,680
Reputation points
Volunteer Moderator
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
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
954 questions
asked 2026-01-20T09:59:52.27+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 25%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Akyo Kamashita
100
Reputation points
commented 2026-01-21T09:48:06.8133333+00:00
Dora-T
12,500
Reputation points Microsoft External Staff
Moderator
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
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
954 questions
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
11,775
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
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
954 questions
asked 2026-01-09T12:35:22.15+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 24%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
McLeod, Barry
0
Reputation points
commented 2026-01-12T18:54:41.97+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 84%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHN%3C/text%3E%3C/svg%3E)
Hani-Ng
10,080
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://dori-uw-1.kuma-moon.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
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
954 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 41%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPL%3C/text%3E%3C/svg%3E)
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
Microsoft 365 and Office | Access | Development
The creation and customization of database applications using Microsoft Access
954 questions
asked 2026-01-04T16:56:34.9466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 80%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Marc Rigaux
20
Reputation points
edited a comment 2026-01-05T12:01:53.3033333+00:00
Karl Donaubauer
2,951
Reputation points MVP