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

Sort by: Updated
Updated Created Answers
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,571 Reputation points
1 answer

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
edited a comment 2026-07-02T08:33:43.1733333+00:00
Rin-L 22,265 Reputation points Microsoft External Staff Moderator
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,571 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 757 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 14,950 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 14,950 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 19,595 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 22,860 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 626 Reputation points
2 answers

Microsoft Access Issue

I can't open Microsoft Access database from outside network.

Microsoft 365 and Office | Access | For business | Windows
asked 2026-04-24T13:32:57.0766667+00:00
Thomas Bianco 0 Reputation points
answered 2026-04-29T07:54:48.62+00:00
Daniel Pineault 626 Reputation points
2 answers

Access does not have "Options" under "File". I am stuck with a big problem because of it.

At application start-up, I always get an error ("Microsoft Access can't change the working directory to [xxx]") after I changed the folder locations for my files to something that is more logical/easier to access (no pun intended). To correct…

Microsoft 365 and Office | Access | For business | Windows
asked 2026-04-28T21:15:44.05+00:00
Thomas Paquette 0 Reputation points
recommended 2026-04-28T21:23:15.5166667+00:00
Clover-L 25 Reputation points Microsoft External Staff Moderator
2 answers

Help Please - strange error message from DoCmd.TransferText

I have a MS Access front end working with an SQL backend and am now getting the bellow error message when I try to do a "TransferText". The error: Err Number: 2391 Err Description: Field '' doesn't exist in destination table…

Microsoft 365 and Office | Access | For business | Windows
asked 2026-04-06T17:35:25.07+00:00
Darren 0 Reputation points
commented 2026-04-20T19:21:20.8066667+00:00
Alexis-NG 17,060 Reputation points Microsoft External Staff Moderator
4 answers One of the answers was accepted by the question author.

Advanced Filter/Sort and Toggle Filter Not working

Within the past couple of weeks, users of multiple Access databases have experienced instances of the Advanced Filter/Sort and Toggle Filter not working (greyed out). The forms have an underlying query and when you go into Advanced Filter/Sort, Access…

Microsoft 365 and Office | Access | For business | Windows
asked 2025-11-10T16:43:14.6266667+00:00
TroyD 65 Reputation points
commented 2026-04-16T01:35:06.9266667+00:00
Dave 20 Reputation points
4 answers One of the answers was accepted by the question author.

Message Trace Option missing under Mail Flow in EAC

We are running a Hybrid Environment; we activate Global Admin access through Privilege Identity Management. We have two roles setup for users, Global Administrator & Exchange Recipient Administrator. Up until a month or so ago, I was able to run a…

Exchange Online
Exchange Online

A cloud-based service included in Microsoft 365, delivering scalable messaging and collaboration features with simplified management and automatic updates.

7,292 questions
Microsoft 365 and Office | Access | For business | Windows
asked 2024-08-06T17:34:43.88+00:00
Mark Bovenzi 60 Reputation points
answered 2026-04-04T23:53:03.4333333+00:00
Phil Ramoel Augustine Roxas Fajilago 20 Reputation points
3 answers One of the answers was accepted by the question author.

Access Build 2603 (19822.20114) - Copy/Delete fails for the entire field content

In previous versions, clicking the label of a Long Text field would select the entire field content, allowing the me to copy or delete everything instantly. In the current build (19822.20114 released on March 24th), this behavior is broken. When clicking…

Microsoft 365 and Office | Access | For business | Windows
asked 2026-04-01T07:31:48.4666667+00:00
Diego Balboni 25 Reputation points
edited the question 2026-04-02T13:05:54.13+00:00
Diego Balboni 25 Reputation points
2 answers

MY access software has blocked me off macros

i am trying to work on microsoft access but it is blocking me from saving anything as it says my macros are affected. how do i unblock it?

Microsoft 365 and Office | Access | For business | Windows
asked 2026-03-12T16:32:11.82+00:00
Sneha Gorania 0 Reputation points
commented 2026-03-23T20:14:23.2366667+00:00
Daniel Pineault 626 Reputation points