270 questions with Microsoft 365 and Office | Access | For business | Other tags

Sort by: Updated
Updated Created Answers
1 answer

How do I open an old .SNP file?

I have some old files that I need to access again. How do I open an old .SNP file?

Microsoft 365 and Office | Access | For business | Other
asked 2026-06-15T10:28:39.8333333+00:00
McCabe, Rachael 0 Reputation points
answered 2026-06-15T11:08:29.7366667+00:00
Marcin Policht 96,590 Reputation points MVP Volunteer Moderator
2 answers One of the answers was accepted by the question author.

MS Access Subforms

I have an Access form that contains a sub form that contains a sub form (three forms - main, sub form, sub sub form). I can create a new record in the main form that resets the subform and the sub sub form with no problems. However, if I try to create…

Microsoft 365 and Office | Access | For business | Other
asked 2026-06-01T14:43:25.4566667+00:00
Gary L Alford 20 Reputation points
commented 2026-06-14T01:52:00.13+00:00
Anthony Stjohn 0 Reputation points
4 answers One of the answers was accepted by the question author.

Microsoft Access Documentor

My Databases are not printing /displaying correctly when I use Database Documenter ex. Id Field in Design View shows a Long Integer in Documenter it shows as Byte, a field like Discard in Design View shows as Yes/No in Documenter it shows as Where. Has…

Microsoft 365 and Office | Access | For business | Other
asked 2026-04-26T01:29:45.6133333+00:00
John Fields 20 Reputation points
edited an answer 2026-04-30T09:15:40.4566667+00:00
Karl Donaubauer 3,366 Reputation points MVP
2 answers One of the answers was accepted by the question author.

How to register a key for Access ?

Hi, I am struggling to verify the key in order to be able to use Access i bought as LTSC and downloaded successfully. The error message coming up on screen saying the key is for volume- licensed version of Microsoft Access and the one I have is not the…

Microsoft 365 and Office | Access | For business | Other
asked 2026-01-19T13:36:51.4133333+00:00
Temenuzhka Dimitrova 20 Reputation points
answered 2026-03-07T14:18:30.0833333+00:00
Rajitram Ram 0 Reputation points
2 answers

MS Access - Compiled after 1st for does not load anything

I have an application that I have worked on for some time and I am at the stage of distribution and I have a strange issue... Compile - Success frmLogin - success frmMainMenu - Fails to load the mani menu for loads correctly when I run the code but…

Microsoft 365 and Office | Access | For business | Other
asked 2026-02-20T21:47:09.59+00:00
Phillip J. Seaman 0 Reputation points
edited an answer 2026-02-23T09:55:56.3166667+00:00
Gabriel-N 20,050 Reputation points Microsoft External Staff Moderator
2 answers

When I try to open my access database, it gives me this error message:

Is there anything I can do to not mess it up and to be able to use it?

Microsoft 365 and Office | Access | For business | Other
asked 2026-02-17T02:40:26.6566667+00:00
MB 0 Reputation points
commented 2026-02-18T08:05:00.99+00:00
Anonymous
3 answers One of the answers was accepted by the question author.

“The database has been placed in a state by user ‘Admin’ on machine ‘LOCALHOST’ that prevents it from being opened or locked.”

Hi, I’m experiencing an issue with Microsoft Access and would appreciate some guidance. I’m using Microsoft Access 365 (Microsoft 365 Apps for enterprise) on Windows 11 Pro, working with an .accdb database stored on my local machine. The issue occurs…

Microsoft 365 and Office | Access | For business | Other
asked 2026-01-24T05:55:07.24+00:00
Wright Kenia 40 Reputation points
answered 2026-02-10T10:36:50.97+00:00
Carl Walker 0 Reputation points
2 answers

How to improve performance for access database

Access application loads very slowly while connecting to Access database on network drive

Microsoft 365 and Office | Access | For business | Other
asked 2026-02-05T21:08:36.4+00:00
Ramnarine, Sonny (MTO) 1 Reputation point
commented 2026-02-09T07:40:48.4466667+00:00
Dora-T 15,315 Reputation points Microsoft External Staff Moderator
3 answers

Microsoft Access Database Engine supporting issue

Hi Folks, After the Microsoft 365 Apps Enterprise (EN) update on 16 December 2025, one of the applications on my machine—Monogram.CS—started experiencing issues due to a dependency on Microsoft 365 Apps Enterprise. Following the update, launching the app…

Microsoft 365 and Office | Access | For business | Other
asked 2026-02-02T13:10:41.77+00:00
Kota, Putal Reddy 0 Reputation points
commented 2026-02-03T15:15:03.1966667+00:00
Gabriel-N 20,050 Reputation points Microsoft External Staff Moderator
3 answers

Microsoft Access database engine cannot find the input table or query '|'

I have a macro that is suddenly "broken". When I try to run it, I get a window that shows Error Number: 3018. And my only option is to "Stop All Macros". When I close that window, I get this message: The Microsoft Database…

Microsoft 365 and Office | Access | For business | Other
asked 2025-12-12T18:50:01.93+00:00
Eberhart, Elizabeth 0 Reputation points
commented 2025-12-30T19:25:12.5933333+00:00
Eberhart, Elizabeth 0 Reputation points
1 answer

Follow up inquiry from previous inquiry regarding Access and real estate short term rentals

This inquiry is an attempt to obtain the final result and procedures used in a previous question which originally posted on Microsoft Support Community.. migrated therefrom to here. Cliff on this site suggested to Phil Stephenson that he suggest a new…

Microsoft 365 and Office | Access | For business | Other
asked 2025-12-30T16:12:40.9966667+00:00
Bill Jones 0 Reputation points
edited a comment 2025-12-30T17:47:50.34+00:00
George Hepworth 22,870 Reputation points Volunteer Moderator
4 answers One of the answers was accepted by the question author.

Are there any plans on the Advance filter changing back to an actual filter instead of a query?

I had used the advanced filter on a regular basis on multiple tables at a time, why was it changed from a filter to a query. Are there any plans to change it back to an actual filter? This has been extremely frustrating. The query doesn't work well…

Microsoft 365 and Office | Access | For business | Other
asked 2025-11-11T16:37:14.0666667+00:00
Kim Stout 20 Reputation points
edited an answer 2025-11-12T21:53:11.5033333+00:00
George Hepworth 22,870 Reputation points Volunteer Moderator
3 answers One of the answers was accepted by the question author.

Can't change tab order in field property sheet of Access form

Just lost the functionality of setting the tab order for a field by entering a number in the field's properties. For example, if the tab order is set to 2 for a particular field, and I change it to 4 (where greater than 4 fields exist in the form), the…

Microsoft 365 and Office | Access | For business | Other
asked 2025-10-01T02:15:00.99+00:00
TroyD 65 Reputation points
edited a comment 2025-10-10T07:42:45.0033333+00:00
Anonymous
1 answer One of the answers was accepted by the question author.

How to get Not Like statement to work in Access

I'm trying to isolate typing mistakes in one column of data vs. another using the "not like" statement in an Access query but it doesn't seem to be working. For example, I have two columns of numbers and a third "total" column. If the…

Microsoft 365 and Office | Access | For business | Other
asked 2025-10-01T18:40:34.8833333+00:00
Starr N 20 Reputation points
edited a comment 2025-10-04T15:08:03.58+00:00
Ken Sheridan 3,571 Reputation points
0 answers

DLookup To Calculate Fields On A Report

I have a simple database called the Incident Management System. I have a lookup field called "Status," which has the values "Completed," "Delayed," and "Ongoing." I want to use a DLookup function to calculate…

Microsoft 365 and Office | Access | For business | Other
asked 2025-06-22T19:03:33+00:00
Anonymous
edited the question 2025-07-22T12:28:58.4166667+00:00
George Hepworth 22,870 Reputation points Volunteer Moderator
5 answers

Access VBA code to close form and not save changes made

Hello, I have created a form in Access that has a command button for the user to select when they want to exit the form without committing the changes made. The code attached to the button's click event is: Private Sub btnExitDontSave_Click()…

Microsoft 365 and Office | Access | For business | Other
asked 2025-04-30T09:14:27+00:00
Anonymous
4 answers

How do I fix the SendObject failure with MS Access and the new version of Outlook

For years I have used the SendObject to send a Report from MS Access as a PDF attachment using Outlook. Now is seems none of my previous code to automate emails from within MS Access works anymore. I have searched for a solution but have not been…

Microsoft 365 and Office | Access | For business | Other
asked 2025-04-07T08:44:54+00:00
Anonymous
6 answers

Issue with MS Access 365 not releasing Forms from Forms collection

I'm running MS Access Version 2502 (Build 18526.20168 Click-to-Run), Current Channel and I've noticed that in certain scenario Forms are not being removed from Forms collection. If I create a new database with a single form called 'Form1' and add 2…

Microsoft 365 and Office | Access | For business | Other
asked 2025-04-02T12:15:56+00:00
Anonymous
12 answers One of the answers was accepted by the question author.

In Access, VB, I am needing help with a IF/THEN scenario involving dates.

I have a form that I use for task scheduling and keeping track of dates when I performed that task. It is a simple form where I have a "STATUS" field combo box with "Not Started" and "Completed" for source options. Also,…

Microsoft 365 and Office | Access | For business | Other
asked 2025-05-27T15:00:28+00:00
Anonymous
2 answers

Migrating from Microsoft Access to Shopify

I'm working on migrating a SQL database from Microsoft Access to Shopify and wonder if anyone has any experience doing this? The site I'm working on has legacy issues, including old customer CMS databases that are on Microsoft Access that I need to get…

Microsoft 365 and Office | Access | For business | Other
asked 2025-05-18T06:53:46+00:00
Anonymous