419 questions
419 questions with Microsoft 365 and Office | Access | For business | Windows tags
3 answers
One of the answers was accepted by the question author.
How can I track invoices paid on various contracts using Access?
I have an Access database with a 100 contracts in it. For each contract I need to log the invoices paid against it keeping a running balance of the available funds for each contract. How can I do that? Thanks!
Microsoft 365 and Office | Access | For business | Windows
asked 2025-07-02T14:26:38.6566667+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, 61%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Mercer-Auen, Lisa
20
Reputation points
answered 2025-07-11T11:51:52.24+00:00
Ken Sheridan
2,856
Reputation points
4 answers
How to autoset a table field at the beginning of the year? MS Access
I am new to ms access and am trying to make a database to keep track of my employee's vacation and personal days. Every year, each employee has to use their personal days, and on the first of the year, it resets to 2. How do I make a trigger to reset…
Microsoft 365 and Office | Access | For business | Windows
asked 2025-06-26T19:22:47.9166667+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(99.2, 40%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
bpeace
0
Reputation points
answered 2025-07-07T17:28:29.5033333+00:00
Ken Sheridan
2,856
Reputation points
1 answer
Clean old SharePoint sites in "Get External Data" MSAccess wizard
The "Get External Data" MSAccess wizard keeps a list of every SharePoint site you ever used to link to in the "Specify a SharePoint site" list. How can I clean this list? This is particulary important if I need to distribute the…
Microsoft 365 and Office | SharePoint | For business | Windows
11,730 questions
Microsoft 365 and Office | Access | For business | Windows
![](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(57.599999999999994, 3%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVC%3C/text%3E%3C/svg%3E)
![](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(310.4, 86%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETO%3C/text%3E%3C/svg%3E)
2 answers
where can I find Microsoft.ACE.OLEDB.12.0 Provider 64-bit
hello, We need the driver "Microsoft.ACE.OLEDB.12.0 Provider 64-bit", but it is no longer available! Could you provide me with a download link? Regards
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
571 questions
Windows for business | Windows Server | User experience | Other
20,220 questions
SQL Server | Other
14,506 questions
Microsoft 365 and Office | Access | For business | Windows
asked 2024-04-19T01:28:50.96+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(192, 68%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEK%3C/text%3E%3C/svg%3E)
Elham Khalaji
0
Reputation points
commented 2025-04-01T14:57:32.6733333+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, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky
26,596
Reputation points
4 answers
One of the answers was accepted by the question author.
Active content in this file is blocked. Trust Center
I am trying to migrate several tables from Microsoft Access file located on channel into teams to Microsoft SharePoint online. When I try to do it using "DataBase tool" --> "SharePoint" and select the SharePoint site appears the…
Microsoft 365 and Office | Office Online Server
754 questions
Microsoft 365 and Office | Install, redeem, activate | For business | Windows
Microsoft 365 and Office | SharePoint | For business | Windows
11,730 questions
Microsoft 365 and Office | Access | For business | Windows
asked 2023-07-24T11:26:34.7566667+00:00
Antonio Tudela
76
Reputation points
answered 2025-03-18T18:45:32.8866667+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(169.60000000000002, 97%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
dolores benitez
0
Reputation points
2 answers
Windows 10 + access MDB file shared in windows 2012R2 server access too slow
I have several computers with windows 10 Pro, running applications that access MDB files that are in a network drive in a windows 2012R2 Server. The programs run very slow. The same computer computer with Windows XP runs the applications with no…
Windows for business | Windows Client for IT Pros | Devices and deployment | Set up, install, or upgrade
Windows for business | Windows Client for IT Pros | Networking | Network connectivity and file sharing
Microsoft 365 and Office | Access | For business | Windows
![](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(73.60000000000001, 1%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF%3C/text%3E%3C/svg%3E)
3 answers
How to determine/Identify which Users in my Domain environment is able to join Domain on work stations
Hi. My issue is we have only allow 1 users in my enviroment is able to join domain on workstations. but i randomly checked with some users accounts their accounts are also able to join domain to work stations. So how can i identify which users hve…
Windows for business | Windows Server | User experience | PowerShell
Windows for business | Windows Client for IT Pros | User experience | Other
Microsoft Security | Microsoft Graph
13,745 questions
Microsoft Security | Microsoft Entra | Other
2,616 questions
Microsoft 365 and Office | Access | For business | Windows
asked 2023-01-19T07:21:56.5466667+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(179.20000000000002, 42%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Muhammad Moiz
0
Reputation points
answered 2025-02-26T17:02:19+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(310.4, 97%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Haim
26
Reputation points
1 answer
giving a user access to a shared file , approving access still not working
giving a user access to a shared file , approving access still not working
Microsoft 365 and Office | SharePoint | For business | Windows
11,730 questions
Microsoft 365 and Office | Excel | For business | Windows
4,003 questions
Microsoft 365 and Office | Access | For business | Windows
asked 2025-02-17T15:34:04.6+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, 41%, 35%)' 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)
Chrishaun Douglas
0
Reputation points
commented 2025-02-21T09:47:39.9966667+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, 51%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EED%3C/text%3E%3C/svg%3E)
Emily Du-MSFT
51,866
Reputation points Microsoft External Staff
0 answers
I cannot use the sandbox with my account
I created a Sandbox space to practice. Yesterday I could use it but today it ias asking for a suscription, even if the default directory has a suscription.
Microsoft 365 and Office | Access | For business | Windows
asked 2025-02-19T09:52:04.42+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, 65%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAL%3C/text%3E%3C/svg%3E)
Ana Álvarez
0
Reputation points
commented 2025-02-20T15:39:38.6966667+00:00
George Hepworth
10
Reputation points
Volunteer Moderator
2 answers
One of the answers was accepted by the question author.
Will Microsoft Access have an End-of-Life? If so, when?
I am inquiring about the End of life for Microsoft Access in Office 365 products suite. Please provide dates as to end of life and end of support. Thank you!
Microsoft 365 and Office | Access | For business | Windows
asked 2024-01-26T18:04:32.2033333+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(92.8, 18%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBE%3C/text%3E%3C/svg%3E)
Brenda Edders
35
Reputation points
edited an answer 2025-02-17T14:45:11.6766667+00:00
George Hepworth
10
Reputation points
Volunteer Moderator
2 answers
MIGRATE DATABASE TO ACCESS 365
Migrate 2013 Access database to Office 365 and share it with a group
Microsoft 365 and Office | Access | For business | Windows
asked 2025-02-14T16:08:06.16+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(60.8, 61%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERL%3C/text%3E%3C/svg%3E)
Radise Lucas
0
Reputation points
commented 2025-02-16T15:17:04.5733333+00:00
Sasha Froyland
1
Reputation point
2 answers
Microsoft Access latest documentation
Hello, Where can i find the latest document on MSFT's Access DB ? thanks, Cooper
Microsoft 365 and Office | Access | For business | Windows
asked 2025-02-13T00:40:21.57+00:00
HomerAlpha
6
Reputation points
answered 2025-02-13T15:16:35.6533333+00:00
George Hepworth
10
Reputation points
Volunteer Moderator
2 answers
One of the answers was accepted by the question author.
how to fix "Failed to load microsoft.date.sqlclient version = 5.0.0.0 file or assembly..."
I tried to recreate projects, installed the access engine, added microsoft.data.sqlclient through nuGet, installed various database extensions, watched a lot on the Internet, nothing helped. I need to add an access database. What should I do?
Microsoft 365 and Office | Access | Development
915 questions
Microsoft 365 and Office | Access | For business | Windows
Developer technologies | C#
11,584 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(220.8, 70%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
1 answer
How to set up client permissions on secure shared database
Hi. I am building a database for a person who audits hospitals and so the database is shared, between her and another lady, on a very secure site. The problem we are having is when I program it to do something, like show P1 from a checkbox to say P1 or…
Microsoft 365 and Office | Access | Development
915 questions
Microsoft 365 and Office | Access | For business | Windows
asked 2024-06-21T14:37:39.87+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(131.20000000000002, 54%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
CC
0
Reputation points
commented 2025-01-28T15:16:53.07+00:00
George Hepworth
10
Reputation points
Volunteer Moderator
1 answer
One of the answers was accepted by the question author.
Can I use ODBC Driver for SQL Server after Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025 ?
I am using ODBC Driver for SQL Server version 18 to connect to an Azure SQL Database Can I use ODBC Driver for SQL Server after Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025 ?
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,367 questions
Microsoft 365 and Office | Access | For business | Windows
asked 2025-01-28T08:21:46.43+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(102.4, 92%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Sigurd Grønvigh - Tromek Produksjon AS
20
Reputation points
accepted 2025-01-28T09:23:48.5866667+00:00
Sigurd Grønvigh - Tromek Produksjon AS
20
Reputation points
1 answer
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…
Windows for business | Windows Client for IT Pros | User experience | Other
Microsoft 365 and Office | Access | For business | Windows
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
commented 2025-01-24T14:27:33.9666667+00:00
VASARI Akos
0
Reputation points
2 answers
One of the answers was accepted by the question author.
Is it possible to connect a Google Forms to a linked Microsoft Access table using VBA code?
Is it possible to connect a Google Forms Survey (URL website) directly to a linked table in a Microsoft Access database and pull the respondents' responses directly into a linked MS table using VBA code? Currently, when respondents submit their responses…
Microsoft 365 and Office | Access | Development
915 questions
Microsoft 365 and Office | Development | Microsoft 365 Publishing
Microsoft 365 and Office | Access | For business | Windows
![](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(108.80000000000001, 74%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
How to remove duplicates from an Access table using SQL
I’m responsible for a non-profit’s annual fundraiser in which people can send a product to a list of receivers at a fixed cost per receiver. Each receiver gets only one product, no matter how many senders are sending to them, along with a card listing…
Microsoft 365 and Office | Access | For business | Windows
asked 2025-01-14T17:43:17.7766667+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(76.8, 72%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERG%3C/text%3E%3C/svg%3E)
Rich Goldberg
161
Reputation points
accepted 2025-01-14T20:49:49.34+00:00
Rich Goldberg
161
Reputation points
1 answer
One of the answers was accepted by the question author.
Looking for Beginner Learning Resources for Microsoft 365 Access
Does anyone know if there is a learning path for Microsoft 365 Access? I would appreciate if someone could give a link of a module referred to beginners in Access to help me get started with database management
Microsoft 365 and Office | Install, redeem, activate | For business | Windows
Microsoft 365 and Office | Access | For business | Windows
asked 2024-12-29T19:07:31.9733333+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, 50%, 19%)' 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)
Άννα Κωσταρά
40
Reputation points
commented 2025-01-14T20:40:02.5833333+00:00
George Hepworth
10
Reputation points
Volunteer Moderator
1 answer
SSMS Import of MS Access accdb external component has thrown an exception (System.Data)
I've been using SQL Server Management Studio for some time to import tables from MS Access into SQL Server. Now I get an error External component has thrown an exception. (System.Data) when I choose an Access database to import from. This worked only a…
SQL Server | Other
14,506 questions
Microsoft 365 and Office | Access | For business | Windows
asked 2024-12-10T09:58:07.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(144, 11%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERW%3C/text%3E%3C/svg%3E)
Richard Williams
15
Reputation points
commented 2025-01-10T12:20:15.0066667+00:00
Richard Williams
15
Reputation points