20,894 questions

Sort by: Updated
2 answers One of the answers was accepted by the question author.

Access Reports can no longer print to Microsoft PDF

since 11/11/2026 can no longer print large file size Access Reports to Microsoft PDF

Microsoft 365 and Office | Access | For home | Windows
asked 2026-11-14T13:02:58.12+00:00
Laura Carlanell 20 Reputation points
accepted 2026-11-14T13:35:33.0966667+00:00
Laura Carlanell 20 Reputation points
2 answers One of the answers was accepted by the question author.

Login/Password Security On A Acess Database

I have a Microsoft Access 2007 database in a network environment that is split into a front end and back end setup.  I currently have a d/b password set for security as there are limited number of users, but I would like to change that to each user…

Microsoft 365 and Office | Access | For home | Windows
asked 2014-05-01T18:12:43+00:00
Anonymous
edited an answer 2026-11-13T05:19:53.26+00:00
Anonymous
15 answers One of the answers was accepted by the question author.

Generate set of Passwords in Access

I ha ve an access database that contains the following columns : UserID |First name  | Last Name | Username I would like to add a password column as well and generate random passwords for the number of records found in my database , example if I have 50…

Microsoft 365 and Office | Access | For home | Windows
asked 2011-06-21T06:23:05+00:00
Anonymous
edited an answer 2026-11-13T05:16:22.47+00:00
Anonymous
1 answer

VBA, ODBC Authentication, and Passthroughs

My company is in the process of meeting certain guidelines to make steps toward going public.  One of those steps involves analysts to have to change their ODBC passwords every 30 days.   Not awful for adhoc type deals, but I have a reporting box that…

Microsoft 365 and Office | Access | For home | Windows
asked 2011-02-23T16:19:35+00:00
Anonymous
edited an answer 2026-11-13T05:15:51.7433333+00:00
Anonymous
1 answer

ODBC Database sources across multiple personel and Access database queries.

Currently running linked ODBC database source tables into multiple Access queries.  These tables are imported as a linked table to the source and granted permissions to them through one main password into the server.  Effective February 2010, a new…

Microsoft 365 and Office | Access | For home | Windows
asked 2010-03-02T22:47:15+00:00
Anonymous
edited an answer 2026-11-13T05:15:27.34+00:00
Anonymous
1 answer

How to get data from an encrypted 2016 access database in excel 2016

I am trying to get data from a 2016 access database into excel 2016.  If I apply no encryption to the access database it's very easy to access tables in excel simply by selecting Data->get-data->from-database->From Microsoft access database then…

Microsoft 365 and Office | Access | For home | Windows
asked 2017-08-24T18:41:33+00:00
Anonymous
edited an answer 2026-11-13T02:52:25.6+00:00
Anonymous
4 answers

How do I move a field to the left or right

I want a field to be in a different place from left to right. How do I move it.

Microsoft 365 and Office | Access | For home | Windows
asked 2026-11-10T20:15:12.2666667+00:00
Dan Roach 0 Reputation points
answered 2026-11-12T23:17:23.69+00:00
Duane Hookom 27,035 Reputation points Volunteer Moderator
2 answers

How do I freeze columns in Access

I want to freeze columns in Access to ID the rows as I move to the right. I cannot find an icon as with other Microsoft applications.

Microsoft 365 and Office | Access | For home | Windows
asked 2026-11-10T20:08:18.96+00:00
Dan Roach 0 Reputation points
recommended 2026-11-10T23:56:19.07+00:00
George Hepworth 23,135 Reputation points Volunteer Moderator
2 answers

i would like to download microsoft access on to my PC computer

i have an Office 365 Family subscription. how can i download microsoft access onto my PC?

Microsoft 365 and Office | Access | For home | Windows
asked 2026-10-26T01:40:28.67+00:00
Vince DiCecco 0 Reputation points
commented 2026-10-26T23:25:43.8566667+00:00
Jade Ng 16,955 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

How to find a specific item from thousands

I have a giant table that lists items that customers can purchase. The table has just 2 fields: unique name and detailed description. However, this is hardly useful to a customer who is selecting an item by the attributes in the description. These…

Microsoft 365 and Office | Access | For home | Windows
asked 2026-10-26T00:54:18.6533333+00:00
OLUGBENGA AJAO 40 Reputation points
commented 2026-10-26T10:43:57.9+00:00
Dora-T 2,425 Reputation points Independent Advisor
5 answers

A form in MS-Access that has worked since 2016 now fails on the report field with =Date() as the control

The same field is used on a number of reports to show the date when the report was printed. It is an unbound field with "=Date()" to provide the current system date (in medium date format). This has worked wonderfully well and simply for the…

Microsoft 365 and Office | Access | For home | Windows
asked 2026-09-12T07:58:44.5666667+00:00
Neville Williams 0 Reputation points
commented 2026-10-18T23:02:31.61+00:00
Daniel Pineault 631 Reputation points
2 answers One of the answers was accepted by the question author.

My Microsoft ACCESS report

My Microsoft ACCESS report does not display data when print preview is selected

Microsoft 365 and Office | Access | For home | Windows
asked 2026-10-15T18:34:09.9566667+00:00
Ann Fishkin 20 Reputation points
accepted 2026-10-15T19:26:51.73+00:00
Ann Fishkin 20 Reputation points
1 answer

Access Product key linked to closed account

My MS Access product key is linked to my old MS Windows sign-in, online account, which is closed for more the 60 days. How do I link the product key to my new MS Windows sign-in, online account? Access now keeps asking me to activate it and it will not…

Microsoft 365 and Office | Access | For home | Windows
asked 2026-10-14T21:51:12.5233333+00:00
Lawrence Foreman 0 Reputation points
answered 2026-10-14T22:07:09.01+00:00
Kai-L 21,875 Reputation points Microsoft External Staff Moderator
3 answers One of the answers was accepted by the question author.

TimeEntryValidation Geo ?

where can I find the place to enter: TimeEntryValidation Geo ?

Microsoft 365 and Office | Access | For home | Windows
asked 2026-10-09T08:21:16.6866667+00:00
Dlovan Mahrof 20 Reputation points
answered 2026-10-09T08:48:46.6633333+00:00
Demi Nguyen 3,050 Reputation points Independent Advisor
1 answer

microsoft access append query key violation when there is no primary key

I have Access as a subscription of Microsoft 365 under Windows 11 Pro. I am trying to run an append query, but I get an error message: "didn't add records due to key violations". However, the table I am trying to append it to, doesn't have ANY…

Microsoft 365 and Office | Access | For home | Windows
asked 2026-09-27T01:41:22.0233333+00:00
Harold E1 45 Reputation points
commented 2026-09-30T02:22:37.8366667+00:00
Teddie Dang 2,270 Reputation points Independent Advisor
2 answers

Cannot enforce referential integrity, even though there are NO records in the child table without an ID in the parent table

Cannot enforce referential integrity, even though there are NO records in the child table without an ID in the parent table.

Microsoft 365 and Office | Access | For home | Windows
asked 2026-09-27T01:47:08.3433333+00:00
Harold E1 45 Reputation points
recommended 2026-09-30T02:18:24.2633333+00:00
Kai-Ex 2,665 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

How do I install Microsoft Access on my new Windows 11 computer?

I have used Access for decades. I just bought a new computer with Windows 11 and downloaded Office 365 since my subscription for Office 365 Family was current. I then upgraded to Office 365 Premium to get better CoPilot experience. But now I cannot find…

Microsoft 365 and Office | Access | For home | Windows
asked 2026-09-24T20:45:40.9066667+00:00
Dan Bishop 20 Reputation points
accepted 2026-09-26T21:06:13.8466667+00:00
Dan Bishop 20 Reputation points
1 answer One of the answers was accepted by the question author.

how to solve the run problem it dont let me click it

it dont let me click the run button on microsoft access.

Microsoft 365 and Office | Access | For home | Windows
asked 2026-09-18T21:04:35.4866667+00:00
Marisol Lopez 20 Reputation points
commented 2026-09-18T21:19:06.3033333+00:00
Marisol Lopez 20 Reputation points
2 answers

Microsoft Access 2000 problem started yesterday 8/11/26. I can see header in Report View but have disappeared in Print View. Does anyone know how to restore/fix.

Microsoft Access 2000 problem started yesterday 8/11/26. I can see header in Report View but have disappeared in Print View. Does anyone know how to restore/fix.

Microsoft 365 and Office | Access | For home | Windows
asked 2026-08-11T20:36:25.9733333+00:00
Edna G 5 Reputation points
edited an answer 2026-09-11T11:25:37.0433333+00:00
Karl Donaubauer 4,016 Reputation points MVP
1 answer

Decimal field error

I received this error. How do I fix it. The decimal field's precision is too small to accept the numeric you attempted to add. (Error 3761)

Microsoft 365 and Office | Access | For home | Windows
asked 2026-09-10T13:29:42.9666667+00:00
Nichols, Shanyse 0 Reputation points
answered 2026-09-10T13:33:45.02+00:00
Marcin Policht 113.6K Reputation points MVP Volunteer Moderator