Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
2,040 questions
3 answers
Ublock Access Files
Looking to unlock some Access files, but there is nothing beyond the "General" tab, when delvling into "Properties"
Microsoft 365 and Office | Access | For business | Windows
asked
2026-11-02T12:59:17.4033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 34%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOW%3C/text%3E%3C/svg%3E)
Oscar Walters
0
Reputation points
answered
2026-11-02T18:11:51.0366667+00:00
DBG
11,801
Reputation points
Volunteer 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
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
2,040 questions
asked
2026-06-26T14:18:40.1566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 8%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Susan Chadwick
20
Reputation points
answered
2026-11-01T01:00:33.4633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 19%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBP%3C/text%3E%3C/svg%3E)
Balu Prem Kumar
0
Reputation points
3 answers
One of the answers was accepted by the question author.
Access error 2004 There isn't enough memory to perform this operation - It's happening again!
It's happening again, Microsoft. Microsoft Access for Microsoft 365 MSO (Version 2610 Build 16.0.20527.20088) 64-bit Access error 2004 There isn't enough memory to perform this operation when trying to open a report. Would you please correct this asap…
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
2,040 questions
asked
2026-10-23T15:55:18.08+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 77%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECF%3C/text%3E%3C/svg%3E)
COW Farmer
90
Reputation points
accepted
2026-10-29T13:25:59.5566667+00:00
COW Farmer
90
Reputation points
1 answer
Windows 11 home, Access 97 32 bit, Epson LX-350 tipo de letra ha cambiado en impresión y en informe en Access
Microsoft Access 97 en Windows 11 Home: texto apiñado en pantalla y problemas de impresión con Epson LX-350 Solicito ayuda para diagnosticar un problema de representación de texto en una aplicación heredada de Microsoft Access 97, ejecutada en Windows 11…
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
2,040 questions
asked
2026-10-19T18:56:46.13+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 64%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Cesar Morales
0
Reputation points
edited an answer
2026-10-19T21:49:14.37+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 15%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jack-Bu
7,220
Reputation points Microsoft External Staff
Moderator
1 answer
Help Please!! - Append query throw Key Violation Error
I have an append query appending records to the table (tblIntake) and I am getting a key violation error and I am trying to figure out why is is throwing a key violation error. I do not write any values to the primary key (IntakeID). I have done the…
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
2,040 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 68%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
4 answers
error 2004
I have frequently error 2004 in Access when to try open object like report.
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
2,040 questions
asked
2026-10-05T07:32:28.6033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 28.000000000000004%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDA%3C/text%3E%3C/svg%3E)
Dall'Asta, Massimo
0
Reputation points
recommended
2026-10-06T09:02:34.5433333+00:00
Stefan Blom
357.1K
Reputation points MVP
Volunteer Moderator
4 answers
One of the answers was accepted by the question author.
IMMEDIATE! Access error 2004 There isn't enough memory to perform this operation
It appears that the same issue from June 2023 is happening again. At that time I posted the following to the MS Community the issue being experienced by numerous clients. KB5026446 seems to cause Access error 2004 There isn't enough memory to perform…
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
2,040 questions
asked
2026-09-15T20:04:12.8666667+00:00
COW Farmer
90
Reputation points
commented
2026-10-03T18:58:15.91+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 66%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Mike
0
Reputation points
2 answers
Access database doesnt save entries to existing forms
When i add data to a box in the Access database it is not saved after going to another form
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
2,040 questions
asked
2026-09-23T21:10:45.6766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 43%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMO%3C/text%3E%3C/svg%3E)
Mario Ostrowski
0
Reputation points
commented
2026-09-24T20:59:12.48+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 25%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI%3C/text%3E%3C/svg%3E)
Ivory
2,610
Reputation points
Independent Advisor
3 answers
duplicates within a table
i have a table that contains the following CallDate Customer Callid i seem to have a load of duplicates,i want to get rid of all the duplicates but leave one remaining. im a novice so is there a basic way to do this please or anyone who has the skills…
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
2,040 questions
asked
2026-09-24T16:32:38.2733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 25%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Mark Powell
0
Reputation points
answered
2026-09-24T16:46:08.48+00:00
George Hepworth
23,135
Reputation points
Volunteer Moderator
3 answers
One of the answers was accepted by the question author.
How can I get a sequential numbered list for a Microsoft 365 Access SQL Dynamic Query
I have a table named WaterTestChemUset that has 25 fields. I want to be able to select the data from any of these fields using a combo box located on a form. The following SQL query selects all records from the underlying table WaterTestChemUset great…
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
2,040 questions
asked
2026-09-21T21:12:39.59+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 86%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
Carol Davis
25
Reputation points
commented
2026-09-22T15:06:50.49+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 86%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKL%3C/text%3E%3C/svg%3E)
Kai-L
21,095
Reputation points Microsoft External Staff
Moderator
2 answers
My access database has opened in design view not a user view
My access database has opened in design view not a user view How do I get the user view back
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
2,040 questions
asked
2026-09-17T11:23:44.0666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 94%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Accounts
0
Reputation points
commented
2026-09-18T12:20:14.6166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 97%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKT%3C/text%3E%3C/svg%3E)
Kristen Tran
2,785
Reputation points
Independent Advisor
3 answers
Normal form view missing for Access database version 2608
I have an access database that was written for us with a personallised ribbon. I normally open the database and have a personalised form view that allows me to search, update and create records. I have opened it up as normal and all I can see is the…
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
2,040 questions
asked
2026-09-17T11:15:58.2233333+00:00
Accounts
0
Reputation points
answered
2026-09-17T12:13:24.4266667+00:00
George Hepworth
23,135
Reputation points
Volunteer Moderator
4 answers
My Access Report is printing differently.
My access report is printing a form that has lines in it. The lines are now about 1/8 of the regular size and up in the Left corner of the page. The rest of the form is printing correctly. How do I fix this?
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
2,040 questions
asked
2026-08-17T15:10:06.49+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 49%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWP%3C/text%3E%3C/svg%3E)
William Pursley
0
Reputation points
answered
2026-09-02T07:53:21.9766667+00:00
Karl Donaubauer
4,016
Reputation points MVP
3 answers
One of the answers was accepted by the question author.
Access formula for calculating part round-trip part one-way mileage
I need help with a formula to calculate the rate for part one-way and part round-trip travel. For example; I have a group of 4 riders traveling from A to B and B to A, however, one of the riders decided not to take the return route. So there were 4 going…
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
2,040 questions
asked
2026-08-27T14:56:58.9266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 15%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Robbie Doo
65
Reputation points
commented
2026-09-01T07:10:54.7266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 95%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERT%3C/text%3E%3C/svg%3E)
Roebe Ta
1,825
Reputation points
Independent Advisor
1 answer
One of the answers was accepted by the question author.
Using report.subreport.hasdata with multiple IIf's
When I'm using (subreport.hasdata.report) feature on main form to pull data with one IIf option, it works fine. However, when I add another IIf, I get and error. For example: =IIf([rpt01_TestCount].[Report].[HasData] And [PU_Loc]=1 And…
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
2,040 questions
asked
2026-08-31T15:30:03.36+00:00
Robbie Doo
65
Reputation points
accepted
2026-08-31T17:53:35.6466667+00:00
Robbie Doo
65
Reputation points
1 answer
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
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
2,040 questions
asked
2026-08-07T15:57:26.1766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 84%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
President CAV
0
Reputation points
edited an answer
2026-08-18T17:28:51.95+00:00
President CAV
0
Reputation points
2 answers
What is the most current Microsoft Jet Database Engine version and how to get the installer package?
We have a legacy software written in VB6, which stores a lot of data in various Access database files. Getting recordsets are working, but getting the values from fields causes problems for some of our customers. For the majority it works fine, but for…
Microsoft 365 and Office | Access | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
2,040 questions
asked
2025-01-24T10:30:54.6133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 91%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVA%3C/text%3E%3C/svg%3E)
VASARI Akos
0
Reputation points
edited the question
2026-08-15T23:44:05.22+00:00
Gérard Oomens
133.6K
Reputation points
Volunteer Moderator
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
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
2,040 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 88%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEG%3C/text%3E%3C/svg%3E)
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
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
2,040 questions
asked
2026-08-11T14:00:28.5733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 48%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECC%3C/text%3E%3C/svg%3E)
Charles Coleman
25
Reputation points
commented
2026-08-12T16:35:15.56+00:00
George Hepworth
23,135
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
Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
2,040 questions
asked
2026-08-11T19:10:38.31+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 4%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWW%3C/text%3E%3C/svg%3E)
William Wade
0
Reputation points
answered
2026-08-11T19:24:50.5066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 62%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
Duane Hookom
27,030
Reputation points
Volunteer Moderator