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

Sort by: Updated
7 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 0 Reputation points
commented 2026-04-22T18:32:43.46+00:00
Richard Bell 0 Reputation points
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 14,990 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
2 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
commented 2026-04-05T13:01:23.2366667+00:00
George Hepworth 22,680 Reputation points Volunteer Moderator
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,132 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
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 551 Reputation points MVP
4 answers

How to autofill a item price on access?

So I've been making a database on access, and its been easy so far. Ive just made a table for the customer, but I've hit a snag. I want it so that when I select my item from the lookup & relationship table, the price (a seperate column) gets filled…

Microsoft 365 and Office | Access | For business | Windows
asked 2026-03-19T01:46:25.8933333+00:00
Grace B 0 Reputation points
commented 2026-03-20T00:43:41.6766667+00:00
Dora-T 12,665 Reputation points Microsoft External Staff Moderator
8 answers

How to copy a record as a new record in MS 365 Access. Facility has been removed.

I know that you cannot 'copy a record as a new record in MS 365 Access' anymore. As the facility has been removed in recent upgrades. I do not believe this is an upgrade but a retrograde step. MS seems to be going backwards and not forward. Is there a…

Microsoft 365 and Office | Access | For business | Windows
asked 2026-03-14T09:09:13.0933333+00:00
grayb 25 Reputation points
commented 2026-03-16T14:02:09.1233333+00:00
George Hepworth 22,680 Reputation points Volunteer Moderator
3 answers

I have a blank page at the beginning of my report.

I have a report that is based on a select query. The select query does not return any blank records. The report has page breaks at each change in product so that all information for each product is grouped together. When the report is opened in print…

Microsoft 365 and Office | Access | For business | Windows
asked 2026-02-26T15:33:00.1266667+00:00
Crupper, Christy A 0 Reputation points
commented 2026-02-26T20:18:05.52+00:00
DBG 11,711 Reputation points Volunteer Moderator
3 answers

Office 365 Access - Missing Backend tools

Developed an application in Access a few months ago all went well and app was completed. Now after some time creating the distribution package I go back to the application, and I keep getting errors "Backend Not Found" . I do not have access…

Microsoft 365 and Office | Access | For business | Windows
asked 2026-02-18T01:51:35.28+00:00
Phillip J. Seaman 0 Reputation points
answered 2026-02-18T04:33:27.34+00:00
Phillip J. Seaman 0 Reputation points
3 answers

disappeared customers

log in over 5000 customers from 2010 to 2023 january 31st 2020 to december 2023 has disappeared

Microsoft 365 and Office | Access | For business | Windows
asked 2026-02-15T23:02:11.31+00:00
randy beams 0 Reputation points
commented 2026-02-17T07:22:28.9466667+00:00
Flora-T 11,775 Reputation points Microsoft External Staff Moderator
1 answer

How to Resolve Azure AD Error Code 500121 Affecting Sign-ins?

I’m facing an Azure AD authentication issue (Error Code: 500121) that has impacted user sign-ins since November 19, 2024. Details include: Tenant ID: 319c9d59-c5f1-48d3-af49-4f959b5e02c1 Object ID: d1f9c470-cb72-409c-9ddd-e47203e63da6 User Account:…

Microsoft Security | Intune | Configuration Manager | Application
Microsoft Security | Microsoft Entra | Microsoft Entra ID
Microsoft 365 and Office | Access | For business | Windows
asked 2024-11-30T10:08:41.2133333+00:00
Moazzem Hossain 70 Reputation points
answered 2026-02-15T13:00:18.96+00:00
Philippe Vaudry 0 Reputation points
2 answers One of the answers was accepted by the question author.

Unable to view PDF in form following January 2026 MS Access Update

As of 1/26/2026, I was able to view a pdf on my MS Access form using the web browser control. After the January 2026 update (1/27/2026). It looks like the web browser control is working, but when it goes to display the pdf, it's just a gray page. There…

Microsoft 365 and Office | Access | For business | Windows
asked 2026-01-28T15:50:45.17+00:00
Avi 20 Reputation points
commented 2026-01-30T02:40:30.22+00:00
Avi 20 Reputation points
2 answers

Access Database Error

Hi there, We have an Access database .mdb file that I believe was created in Access 97. We are now receiving 'Cannot open a database created with a previous version of your application' when trying to open this in the latest Access version. We have tried…

Microsoft 365 and Office | Access | For business | Windows
asked 2026-01-29T15:22:30.49+00:00
Josh Mould 0 Reputation points
answered 2026-01-29T17:09:48.3733333+00:00
DBG 11,711 Reputation points Volunteer Moderator
1 answer

How to fix "ODBC -- connection to '__' failed"

I have a new work laptop (HP, Windows) and I cannot connect to my company's tables (queries) on Access. I am able to open databases from our SharePoint created by my team, but when I try to open a query or any sort of table, I get the ODBC connection…

Microsoft 365 and Office | Access | For business | Windows
asked 2026-02-02T14:51:42.0233333+00:00
Culcasi, Madison (DEP) 0 Reputation points
edited an answer 2026-02-04T06:45:27.1066667+00:00
Flora-T 11,775 Reputation points Microsoft External Staff Moderator
3 answers

How to enable to use MS ACCESS?

I need to use MS ACCESS. but I couldn't found it. How to install and can use MS ACCESS on my Laptop?

Microsoft 365 and Office | Access | For business | Windows
asked 2026-02-03T09:50:38.5233333+00:00
이성호 0 Reputation points
edited an answer 2026-02-04T10:33:01.36+00:00
Stefan Blom 338.4K Reputation points MVP Volunteer Moderator
2 answers

MSACCESS Active X Button creation error, "Invalid use of Null"

When linked to OneDrive, the MSACCESS adds a button to a form; "Invalid Use of Null" error is not a problem. When creating the same form on a thumb drive, the "Invalid Use of Null: error is a problem; stopping the Active X creation? Note…

Microsoft 365 and Office | Access | For business | Windows
asked 2026-02-06T17:17:12.65+00:00
Phillip Corbin 0 Reputation points
commented 2026-02-09T10:32:26.8266667+00:00
Michelle-N 15,135 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Need an expression to show total from a query in a combo box on a form

I have a main form with a combo box control in which I can type or select an application number, then data from the specific record that I selected populates in subforms. What I am trying to add to this main form is a combo box that uses an expression…

Microsoft 365 and Office | Access | For business | Windows
asked 2026-02-11T17:12:54.41+00:00
Culver, Bruce 40 Reputation points
accepted 2026-02-12T13:09:25.87+00:00
Culver, Bruce 40 Reputation points
2 answers

Access labels

I have 50 labels to print off from my contact list in my access database. It is only printing 1 page. How do I get all the labels (all 50) off. thanks

Microsoft 365 and Office | Access | For business | Windows
asked 2026-02-16T11:20:26.03+00:00
Donalds Tours 0 Reputation points
commented 2026-02-17T06:33:18.8533333+00:00
Gabriel-N 16,055 Reputation points Microsoft External Staff Moderator