20,905 questions with Microsoft 365 and Office | Access | For home | Windows tags

Sort by: Updated
2 answers

setting up tables and relationships for a personal book inventory

Is there someone that I could contact (preferably in person but could try to do online) to assist me in setting up a proposed table layouts and relationships for a massive book inventory that I have acquired and need to better organize. I have used…

Microsoft 365 and Office | Access | For home | Windows
asked 2026-07-15T18:51:18.3766667+00:00
Lisa Reid 0 Reputation points
commented 2026-07-16T13:41:16.5433333+00:00
George Hepworth 22,870 Reputation points Volunteer Moderator
6 answers

Recordset is not updateable -- where is help on MS Access 365?

For years I have just used Access 2007 on my laptop, though I have Office 365. As the disc wouldn't work on my Win11 PC, and the laptop has a problem, I finally decided to use the later access, and opened a 2007 database. I updated a number of records…

Microsoft 365 and Office | Access | For home | Windows
asked 2026-07-12T05:42:38.31+00:00
Rob Curtis 0 Reputation points
commented 2026-07-16T08:04:08.42+00:00
Dora-T 15,315 Reputation points Microsoft External Staff Moderator
1 answer

how to create a new data relationship in Access

I am trying to create a new query in Access but cannot work out how to include a surname (from ADDRESS} in a table composed of PAYMENTS data. Can you help?

Microsoft 365 and Office | Access | For home | Windows
asked 2026-07-15T20:58:46.17+00:00
Peter Cleasby 0 Reputation points
answered 2026-07-15T21:04:41.94+00:00
George Hepworth 22,870 Reputation points Volunteer Moderator
4 answers

How do I get multiple users use my Microsoft access database across computers at different locations

Hi everyone, I have designed a Microsoft access database that I am using and it's working fine I have deployed it to some clients and they like it but the major challenges is how to get users remotely use the database at different locations From…

Microsoft 365 and Office | Access | For home | Windows
asked 2026-07-07T20:42:01.5633333+00:00
Faraday 0 Reputation points
answered 2026-07-14T22:33:49.58+00:00
Kai-L 15,550 Reputation points Microsoft External Staff Moderator
1 answer

How do I show the grand total which excludes one sub-account.

Report displayed Sub 1 item1 20.00 item 2 25.00 Total Sub1 = 45.00 Sub 2 Item 3 10.00 Item 4 15.00 Total Sub 2 25.00 Sub 3 Item 5 …

Microsoft 365 and Office | Access | For home | Windows
asked 2026-07-14T03:43:50.1766667+00:00
Art Carino 0 Reputation points
edited an answer 2026-07-14T04:32:50.9+00:00
Duane Hookom 26,840 Reputation points Volunteer Moderator
1 answer

Refund for ACCESS

can I get a refund for ACCESS ? I purched from Microsoft store .

Microsoft 365 and Office | Access | For home | Windows
asked 2026-07-11T15:33:13.0733333+00:00
Joseph Savukinas 0 Reputation points
answered 2026-07-11T16:02:23.17+00:00
Kristen-L 14,820 Reputation points Microsoft External Staff Moderator
2 answers

FM20.dll Missing (in the past 2 weeks), Breaking MS Forms 2.0 Controls in MS Access - How to Replace It?

In the last two weeks, FM20.dll was removed by Windows 11, and now, essential and current applications have stopped working. These are all MS Access-based desktop applications, who specifically use the MS Forms 2.0 Textbox, which is an essential…

Microsoft 365 and Office | Access | For home | Windows
asked 2026-07-06T14:36:14.7933333+00:00
Vexen Crabtree 0 Reputation points
answered 2026-07-07T13:57:24.07+00:00
Vexen Crabtree 0 Reputation points
1 answer One of the answers was accepted by the question author.

Can't decrypt Access mdb file?

I'm caught in a catch-22 with Microsoft Access. I'm trying to open an old mdb file, which has a password. Luckily I have the password, and I have downloaded Access 2007 so I can open the file, but it is prompting me to update to a more recent version.…

Microsoft 365 and Office | Access | For home | Windows
asked 2026-06-30T21:23:34.0566667+00:00
Elayna Gleaton 20 Reputation points
commented 2026-07-02T20:17:28.6633333+00:00
Hendrix-C 18,965 Reputation points Microsoft External Staff Moderator
4 answers

Microsoft 365 Access running very slow the past 2 days.

Just 2 days ago, all my databases were running just fine, up til yesterday! I did a recent Microsoft365 update a couple of days ago. When I launch any of my databases, it runs slow, updates and refreshes very slow. I haven't dont any changes to these…

Microsoft 365 and Office | Access | For home | Windows
asked 2026-06-12T18:45:15.62+00:00
Mike Hermanson 0 Reputation points
commented 2026-06-26T00:52:40.0166667+00:00
Alex 1 Reputation point
2 answers One of the answers was accepted by the question author.

This product key was used with another account - error

I'm trying to use MS Access after reinstalling windows and I'm getting the error "This product key was used with a different account". I've tried logging in with both of my MS accounts and a Google account and all three give the same error. …

Microsoft 365 and Office | Access | For home | Windows
asked 2026-06-23T21:18:57.3166667+00:00
Kristy Throndson 20 Reputation points
commented 2026-06-25T19:15:49.72+00:00
Hin-V 16,405 Reputation points Microsoft External Staff Moderator
2 answers

Human please — I need to speak with a live representative

I have accounts under 2 emails and I would like to install MS Access. I have pd $99 on one account and $288 on another so I should have Access.

Microsoft 365 and Office | Access | For home | Windows
asked 2026-06-23T19:11:10.6866667+00:00
Fred Giles 0 Reputation points
answered 2026-06-24T00:23:34.56+00:00
Stefan Blom 345.4K Reputation points MVP Volunteer Moderator
1 answer

where is my Microsoft access

I have Office 365 family but there is no Access App

Microsoft 365 and Office | Access | For home | Windows
asked 2026-06-12T02:55:13.1333333+00:00
Jerry Mack 0 Reputation points
commented 2026-06-15T14:39:57.9166667+00:00
Michelle-N 20,050 Reputation points Microsoft External Staff Moderator
2 answers

how to fix Microsoft office

Every time I open my access, I get a pop up saying my access has run into a problem, and it needs to be repaired.

Microsoft 365 and Office | Access | For home | Windows
asked 2026-06-13T20:38:20.6866667+00:00
Derrick Kyei Baffour 0 Reputation points
commented 2026-06-14T13:34:48.38+00:00
George Hepworth 22,870 Reputation points Volunteer Moderator
2 answers One of the answers was accepted by the question author.

How to convert a string to proper case

How do I convert a string to proper case? eg samson to Samson

Microsoft 365 and Office | Access | For home | Windows
asked 2026-06-09T10:44:36.7733333+00:00
Dean Isensee 20 Reputation points
edited an answer 2026-06-10T11:52:01.19+00:00
Karl Donaubauer 3,366 Reputation points MVP
5 answers

How to change the background of the Edge browser control in Access 2024

Hello, I'm using the Edge browser control in a report to display photos. The control's background is black. Depending on the size of the displayed photo, I see black bars appearing in the control's empty spaces on the vertical or horizontal sides of…

Microsoft 365 and Office | Access | For home | Windows
asked 2026-05-31T08:12:45.3933333+00:00
jacky Perpète 171 Reputation points
recommended 2026-06-08T13:11:38.9866667+00:00
Gabriel-N 20,050 Reputation points Microsoft External Staff Moderator
3 answers

How to fix Microsoft Access text form field "#Name?" error after Windows 11 update?

After the next to the last Windows update, Microsoft Access form text fields with syntax (one example - =[First Name:] & " " & [Last Name:]) display as "#Name?" The popup error box text displays: The expression On Enter you…

Microsoft 365 and Office | Access | For home | Windows
asked 2026-06-02T16:22:00.61+00:00
Mike 0 Reputation points
commented 2026-06-03T22:54:17.6833333+00:00
Hin-V 16,405 Reputation points Microsoft External Staff Moderator
1 answer

How to fix Access "No Printer Installed On Your Computer" error after windows 11 update.

After the last Windows 11 update, Microsoft Access produces the following error when print is selected: There are currently no printers installed on your computer. To use this feature, you must first install a printer in Windows. For more information…

Microsoft 365 and Office | Access | For home | Windows
asked 2026-06-02T16:50:03.11+00:00
Mike 0 Reputation points
commented 2026-06-03T22:53:21.08+00:00
Hin-V 16,405 Reputation points Microsoft External Staff Moderator
2 answers

protected Access file

I have an Access file or spreadsheet that I have been working on it for several years - but it opened today protected and I can't edit any new data on it. What can I do?

Microsoft 365 and Office | Access | For home | Windows
asked 2026-05-29T14:10:57.0433333+00:00
Jorge Garcia 0 Reputation points
edited a comment 2026-05-30T14:12:52.9933333+00:00
George Hepworth 22,870 Reputation points Volunteer Moderator
1 answer

How to fix unrecognized format on Access

My computer shut down unexpectedly and I now cannot open my Access database because it says it is unrecognized format. I have tried to compact and repair, but it gives the same error message when I try that as well.

Microsoft 365 and Office | Access | For home | Windows
asked 2026-05-24T19:38:50.5033333+00:00
Michael Thompson 0 Reputation points
answered 2026-05-24T19:57:14.59+00:00
Duane Hookom 26,840 Reputation points Volunteer Moderator
2 answers One of the answers was accepted by the question author.

Office 365, Office 2024, and Access.

I asked the dealer from whom I bought PC and office 2024 to support me install access, following guide ( https://support.microsoft.com/en-US/Access/download-and-install-microsoft-365-access-runtime) they say that doing this means I am violating…

Microsoft 365 and Office | Access | For home | Windows
asked 2026-05-19T10:10:09.7966667+00:00
Le Huy Cam 20 Reputation points
answered 2026-05-24T16:35:50.4133333+00:00
Richard Rost 315 Reputation points MVP