2,033 questions with Microsoft 365 and Office | Access | For business | Windows tags

Sort by: Updated
Updated Created Answers
3 answers One of the answers was accepted by the question author.

IMMEDIATE! Access error 2004 There isn't enough memory to perform this operation

It appears that the same issue from June 2023 is happening again. At that time I posted the following to the MS Community the issue being experienced by numerous clients. KB5026446 seems to cause Access error 2004 There isn't enough memory to perform…

Microsoft 365 and Office | Access | For business | Windows
asked 2026-09-15T20:04:12.8666667+00:00
COW Farmer 40 Reputation points
answered 2026-09-17T15:06:34.2766667+00:00
COW Farmer 40 Reputation points
2 answers

My access database has opened in design view not a user view

My access database has opened in design view not a user view How do I get the user view back

Microsoft 365 and Office | Access | For business | Windows
asked 2026-09-17T11:23:44.0666667+00:00
Accounts 0 Reputation points
answered 2026-09-17T12:16:46.52+00:00
George Hepworth 23,120 Reputation points Volunteer Moderator
3 answers

Normal form view missing for Access database version 2608

I have an access database that was written for us with a personallised ribbon. I normally open the database and have a personalised form view that allows me to search, update and create records. I have opened it up as normal and all I can see is the…

Microsoft 365 and Office | Access | For business | Windows
asked 2026-09-17T11:15:58.2233333+00:00
Accounts 0 Reputation points
answered 2026-09-17T12:13:24.4266667+00:00
George Hepworth 23,120 Reputation points Volunteer Moderator
4 answers

My Access Report is printing differently.

My access report is printing a form that has lines in it. The lines are now about 1/8 of the regular size and up in the Left corner of the page. The rest of the form is printing correctly. How do I fix this?

Microsoft 365 and Office | Access | For business | Windows
asked 2026-08-17T15:10:06.49+00:00
William Pursley 0 Reputation points
answered 2026-09-02T07:53:21.9766667+00:00
Karl Donaubauer 3,661 Reputation points MVP
3 answers One of the answers was accepted by the question author.

Access formula for calculating part round-trip part one-way mileage

I need help with a formula to calculate the rate for part one-way and part round-trip travel. For example; I have a group of 4 riders traveling from A to B and B to A, however, one of the riders decided not to take the return route. So there were 4 going…

Microsoft 365 and Office | Access | For business | Windows
asked 2026-08-27T14:56:58.9266667+00:00
Robbie Doo 65 Reputation points
commented 2026-09-01T07:10:54.7266667+00:00
Roebe Ta 1,110 Reputation points Independent Advisor
1 answer One of the answers was accepted by the question author.

Using report.subreport.hasdata with multiple IIf's

When I'm using (subreport.hasdata.report) feature on main form to pull data with one IIf option, it works fine. However, when I add another IIf, I get and error. For example: =IIf([rpt01_TestCount].[Report].[HasData] And [PU_Loc]=1 And…

Microsoft 365 and Office | Access | For business | Windows
asked 2026-08-31T15:30:03.36+00:00
Robbie Doo 65 Reputation points
accepted 2026-08-31T17:53:35.6466667+00:00
Robbie Doo 65 Reputation points
1 answer

how to delete a row of #error in each column in access

I had a row of #error during a import of data and I can't delete any of the row "Not A Valid Bookmark" is there any way to save this import?

Microsoft 365 and Office | Access | For business | Windows
asked 2026-08-07T15:57:26.1766667+00:00
President CAV 0 Reputation points
edited an answer 2026-08-18T17:28:51.95+00:00
President CAV 0 Reputation points
2 answers

What is the most current Microsoft Jet Database Engine version and how to get the installer package?

We have a legacy software written in VB6, which stores a lot of data in various Access database files. Getting recordsets are working, but getting the values from fields causes problems for some of our customers. For the majority it works fine, but for…

Microsoft 365 and Office | Access | For business | Windows
asked 2025-01-24T10:30:54.6133333+00:00
VASARI Akos 0 Reputation points
edited the question 2026-08-15T23:44:05.22+00:00
Gérard Oomens 131.6K Reputation points Volunteer Moderator
1 answer

Need help with Microsoft Access access report not printing page header, page footer or report footer you can see them in report view but not in print view.

Problem started yesterday 8/10/26. I can see header in Report View but have disappeared in Print View. Does anyone know how to restore/fix. See before and after snap shot below. Thanks in advance.

Microsoft 365 and Office | Access | For business | Windows
asked 2026-08-11T20:13:25.2233333+00:00
Edna G 5 Reputation points
commented 2026-08-12T20:04:50.0233333+00:00
Kai-L 19,145 Reputation points Microsoft External Staff Moderator
3 answers One of the answers was accepted by the question author.

Access Reports not printing correctly

Have an Access program that has a report that prints lines between rows. We have one user that the lines are not showing in the Print Preview nor do they print on paper. This issue is affecting only 1 user in the company. No other user seems to be…

Microsoft 365 and Office | Access | For business | Windows
asked 2026-08-11T14:00:28.5733333+00:00
Charles Coleman 25 Reputation points
commented 2026-08-12T16:35:15.56+00:00
George Hepworth 23,120 Reputation points Volunteer Moderator
1 answer

Reports No Longer Printing Lines

I have two clients now, that are using M365 Access, where they are no longer able to print reports with lines or boxes. What is weird is that in Print Preview the lines are missing, but in report view they are there. Changing printers did nothing and…

Microsoft 365 and Office | Access | For business | Windows
asked 2026-08-11T19:10:38.31+00:00
William Wade 0 Reputation points
answered 2026-08-11T19:24:50.5066667+00:00
Duane Hookom 26,935 Reputation points Volunteer Moderator
2 answers

Microsoft Access latest documentation

Hello, Where can i find the latest document on MSFT's Access DB ? thanks, Cooper

Microsoft 365 and Office | Access | For business | Windows
asked 2025-02-13T00:40:21.57+00:00
HomerAlpha 6 Reputation points
commented 2026-07-28T19:30:54.18+00:00
JephenStones 0 Reputation points
3 answers

I created a macro in Microsoft Access 365 and I am blocked by Microsoft Access from using this macro and I can't find a way to unblock macros in access.

I created a macro in Microsoft Access 365 and I am blocked by Microsoft Access from using this macro and I can't find a way to unblock macros in access. I have tried the recommendations to unblock macros provided in Microsoft help but nothing works or I…

Microsoft 365 and Office | Access | For business | Windows
asked 2026-07-27T15:08:00.0533333+00:00
Stanley J Bednarczyk 0 Reputation points
commented 2026-07-27T20:05:45.1633333+00:00
Duane Hookom 26,935 Reputation points Volunteer Moderator
2 answers

After updating Microsoft 365 Apps / Access to build 16.0.20026.20182, our ASP.NET Web API application began crashing. The IIS worker process (w3wp.exe) terminates with an unhandled fault in mso20win32client.dll whenever application code calls into the Acc

After updating Microsoft 365 Apps / Access to build 16.0.20026.20182, our ASP.NET Web API application began crashing. The IIS worker process (w3wp.exe) terminates with an unhandled fault in mso20win32client.dll whenever application code calls into the…

Microsoft 365 and Office | Access | For business | Windows
asked 2026-07-03T09:59:08.09+00:00
Prashant Nichal 0 Reputation points
commented 2026-07-08T20:44:53.1633333+00:00
Karl Donaubauer 3,661 Reputation points MVP
2 answers

Office plus access as one time purchase

Hi Microsoft, I have just started a small business and want Microsoft Office and Microsoft Access. I just want a one time purchase for one computer, how do I do this.

Microsoft 365 and Office | Access | For business | Windows
asked 2026-07-01T07:28:18.07+00:00
William Skeates 0 Reputation points
answered 2026-07-08T18:42:43.9733333+00:00
Richard Rost 315 Reputation points MVP
2 answers

Access Data Base - copying one cell to multiple cells in a selected column

If I want to copy data or a cell with data in it, I would ctrl + c to copy it. I then want to copy that into a column of selected cells that has an existing different value so I can quickly fill those cells all the same. Example. I want to copy…

Microsoft 365 and Office | Access | For business | Windows
asked 2026-06-26T22:32:31.2333333+00:00
Todd Higgins 0 Reputation points
answered 2026-07-02T12:13:41.7433333+00:00
Ken Sheridan 3,581 Reputation points
3 answers One of the answers was accepted by the question author.

Can We Convert Microsoft Access databases into A Newer, Better Tool?

We have a 20+ year old Access database that contains all the customer information for our real estate company. We also use this database to run queries to assist in marketing. Can this all be converted into another data platform that could perhaps run…

Microsoft 365 and Office | Access | For business | Windows
asked 2026-06-26T14:18:40.1566667+00:00
Susan Chadwick 20 Reputation points
accepted 2026-06-29T13:12:13.4533333+00:00
Susan Chadwick 20 Reputation points
2 answers One of the answers was accepted by the question author.

Access Version 2604 build 16.0.20026.20166 "link to folder" options have changed?

When using Microsoft Access, to create a Hyperlink I normally do to "Edit Hyperlink" -> Browse for Folder Then I will paste the folder path, and a list of files in that folder is displayed. There used to be an option to select which types…

Microsoft 365 and Office | Access | For business | Windows
asked 2026-06-16T10:13:06.6066667+00:00
ReidLorraine-2403 20 Reputation points
answered 2026-06-18T13:31:16.73+00:00
Ken Sheridan 3,581 Reputation points
2 answers

How to view .SNP file

I have a number of files in .SNP format, which originally could be opened with the Microsoft Snapshot Viewer which was part of Microsoft Access. I cannot find a safe version of that program to download. How can I view these .SNP files now or convert them…

Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | For business | Windows
asked 2024-11-02T12:44:18.7533333+00:00
Philip Cox 5 Reputation points
answered 2026-06-14T06:37:17.1233333+00:00
Gustav 767 Reputation points MVP
3 answers

How to fix grouping on a report

On a report I made that I run monthly, it is now splitting transactions and I'm not sure why. I have the report grouped on Category and sorted by a field. The category is set to group Z-A, so that "Sale of Goods" comes before "Booth…

Microsoft 365 and Office | Access | For business | Windows
asked 2026-06-07T00:51:33.4333333+00:00
Debbie Burnette 0 Reputation points
commented 2026-06-08T01:52:11.5966667+00:00
Anonymous