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

Sort by: Updated
Updated Created Answers
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 0 Reputation points
commented 2026-08-12T20:04:50.0233333+00:00
Kai-L 17,200 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,030 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,850 Reputation points Volunteer Moderator
1 answer One of the answers was accepted by the question author.

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 20 Reputation points
accepted 2026-08-07T16:36:50.1466667+00:00
President CAV 20 Reputation points
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,850 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,366 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
Dora-T 15,980 Reputation points Microsoft External Staff Moderator
2 answers

On Office 365-Access i got a message - there isn't enough memory to update the display

Hello, When I print to Microsoft print to pdf on Office 365 Access app version 2604 64Bit from a program inside access that our developer in our organiztaion made that when clicking on print to pdf after the user inserted data to a form - The operation…

Microsoft 365 and Office | Access | For business | Windows
asked 2026-04-28T06:32:02.8166667+00:00
Tomer Schuman 0 Reputation points
commented 2026-05-28T06:44:58.07+00:00
Dora-T 15,980 Reputation points Microsoft External Staff Moderator
1 answer

Zmazanie file ACCESS

Dobrý deň, prosím o riešenie problému - nejde mi vymazať starý file ACCESS prikladám screenshot vopred ďakujem za pomoc

Microsoft 365 and Office | Access | For business | Windows
asked 2026-05-04T10:37:38.7333333+00:00
OZVALDOVA Karolina (WLS SK) 0 Reputation points
edited an answer 2026-05-15T07:57:53.0566667+00:00
Gabriel-N 20,670 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

How to reinstall MS Access

I purchased stand alone Access 2019 through Techsoup for non-profits. It did not come as an EXE or MSI but rather a script which automatically installed Access. The program is now showing significant problems and crashes and I would like to reinstall it…

Microsoft 365 and Office | Access | For business | Windows
asked 2026-05-14T17:10:42.13+00:00
Kenneth Gash 20 Reputation points
accepted 2026-05-15T05:28:17.06+00:00
Kenneth Gash 20 Reputation points
1 answer

I want to use an ACCESS file that I created and put on a company server

We use a TAILSCALE server system. Microsoft won't let me identify the file or location as safe. Blocks the Access macros.

Microsoft 365 and Office | Access | For business | Windows
asked 2026-05-13T18:56:28.2833333+00:00
Thaddeus Speed 0 Reputation points
commented 2026-05-13T21:31:02.4866667+00:00
Thaddeus Speed 0 Reputation points
11 answers

Access changing data type on import of file

I have Access through Office 365. This month, the available data types for importing a file have changed. For example, "Double" no longer is available. I cannot find a summary of what data types were removed and what to use in their place. My…

Microsoft 365 and Office | Access | For business | Windows
asked 2026-04-20T14:33:07.59+00:00
Richard Yamamoto 5 Reputation points
answered 2026-05-01T16:37:04.7633333+00:00
Ted Borie 0 Reputation points
5 answers

Access no longer able to create new records in a linked SQL table following recent updates

For some reason when saving a new record into a linked SQL table that contains nvarchar fields (works ok otherwise) Access throws up a 3155 error. On inspecting the SQL insert statement on the SQL server using XEEvent Profiler, an incorrectly formatted…

Microsoft 365 and Office | Access | For business | Windows
asked 2026-04-28T08:47:42.03+00:00
Pete Hadden 1 Reputation point
commented 2026-04-29T14:30:59.07+00:00
George Hepworth 23,030 Reputation points Volunteer Moderator
3 answers

Use an old mdb file in Microsoft Acces

I have an old file .mdb that i used to open in Microsoft Acces in a Windows xp computer but I don't know how to move it to a modern computer without losing macros/scripts.

Microsoft 365 and Office | Access | For business | Windows
asked 2026-04-04T18:30:59.1233333+00:00
Paul Aznar 0 Reputation points
answered 2026-04-29T07:59:11.1566667+00:00
Daniel Pineault 631 Reputation points