Access
A family of Microsoft relational database management systems designed for ease of use.
333 questions
0 answers
2002-2003: Identify Access population event
I use manufacturing software that populates 2002-2003 Access at a certain point in the manufacturing process and then "flushes" the data out when that process concludes. (When the data populates, the user has the option to print reports before…
![](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, 6%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
0 answers
Reset of variables after using the InsertLines method inserting lines of code in a module with access 2021
Hello, Access 2021 version. When inserting a line of code using the <InsertLines> method in a VBA module, I noticed that all program variables were reset after execution. When the line of code using the <InsertLines> method is commented out,…
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
333 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,684 questions
asked 2023-02-22T09:18:55.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(272, 1%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
jacky Perpète
41
Reputation points
edited the question 2023-02-23T06:22:30.7466667+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(153.6, 89%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
Jiachen Li-MSFT
28,076
Reputation points Microsoft Vendor
0 answers
Registering the Microsoft.ACE.
How do I obtain the provider: 'Microsoft.ACE.OLEDB.12.0' for Visual Studio 2022?
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,821 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
333 questions
asked 2023-02-20T21:22:51.6433333+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(6.4, 19%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
Donald Cohen
0
Reputation points
commented 2023-02-21T01:54:36.5866667+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(140.8, 78%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tianyu Sun-MSFT
28,941
Reputation points Microsoft Vendor
0 answers
Configure MS Access Driver in ODBC Data Sources to be read only
Without getting too deep in the weeds, I have an MS Access database (.accdb) and I needed to create a System DNS connection to it in ODBC Data Sources. Did that it works can connect to it and query it, get results all gravy. However, it is kinda…
asked 2023-02-20T23:38:24.26+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(41.6, 50%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENP%3C/text%3E%3C/svg%3E)
Natasha Pilypaitis
0
Reputation points
asked 2023-02-20T23:38:24.26+00:00
Natasha Pilypaitis
0
Reputation points
3 answers
SUM calculation field does not display and/or calculate on Access subform only on certain workstations.
I'm having a very peculiar problem with the form in a front-end Access database. On some computers (Windows 10 version 21H2 and 22H2), a "SUM" field on a sub-form does not display and/or calculate. What's even more odd is that this occurs on…
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,436 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
333 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,684 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
849 questions
Windows 10 Compatibility
Windows 10 Compatibility
Windows 10: A Microsoft operating system that runs on personal computers and tablets.Compatibility: The extent to which hardware or software adheres to an accepted standard.
464 questions
asked 2023-02-10T21:21:25.9033333+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(297.6, 85%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
Lester Miazga
21
Reputation points
answered 2023-02-18T18:48:08.7033333+00:00
Lester Miazga
21
Reputation points
2 answers
One of the answers was accepted by the question author.
How to remove security tab from users the same network
Hi, I encounter this. How do we remove security tab from user, to hide it from being seen from users in the same network. To achieve from this To this. I tried this method, regedit > HKEY_Current User >Software >Microsoft >Window…
Windows Server 2016
Windows Server 2016
A Microsoft server operating system that supports enterprise-level management updated to data storage.
2,425 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
333 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,516 questions
Windows Network
Windows Network
Windows: A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.Network: A group of devices that communicate either wirelessly or via a physical connection.
696 questions
Windows Server Security
Windows Server Security
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Security: The precautions taken to guard against crime, attack, sabotage, espionage, or another threat.
1,774 questions
asked 2023-02-14T08:46:16.3933333+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(262.40000000000003, 48%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EID%3C/text%3E%3C/svg%3E)
IT Depart
151
Reputation points
commented 2023-02-17T11:24:04.68+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(281.6, 80%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETB%3C/text%3E%3C/svg%3E)
Thameur-BOURBITA
32,621
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…
asked 2023-02-03T13:18:28.5766667+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(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)
Víctor
0
Reputation points
commented 2023-02-16T06:26:48.2466667+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(57.599999999999994, 33%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHX%3C/text%3E%3C/svg%3E)
Haoyan Xue_MSFT
21,826
Reputation points Microsoft Vendor
1 answer
I cannot access the 100 euro for Azure as Student from TU Chemnitz why?
Greetings, I currently work for my master thesis but i dont have a credit card. Your page says thats not a problem you can get 100 euro and then do your stuff. I cannot because i always get the message that my Account is regretted even tho i used my uni…
![](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(172.8, 1%, 26%)' 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)
1 answer
How to block a folder able that able to see, but not accessible without permission rights
Hi, How to block a folder able that able to see, but not accessible without permission rights? Example: able to see this Test folder but when clicking on it not able to open the folder. Had tried to edit in the security, and change it to read access…
Windows Server 2016
Windows Server 2016
A Microsoft server operating system that supports enterprise-level management updated to data storage.
2,425 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
333 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,516 questions
Windows Network
Windows Network
Windows: A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.Network: A group of devices that communicate either wirelessly or via a physical connection.
696 questions
Windows Server Security
Windows Server Security
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Security: The precautions taken to guard against crime, attack, sabotage, espionage, or another threat.
1,774 questions
asked 2023-02-15T00:50:20.6333333+00:00
IT Depart
151
Reputation points
edited a comment 2023-02-15T10:16:17.21+00:00
Vadims Podāns
9,116
Reputation points MVP
0 answers
OneNote Access at Tablet
I'd like to use OneNote at PC and tablet as synced company account, but when I try to register company account to OneNote to my tablet OneNote alert me "not able to register company or school account so better to use Gmail or Yahoo! e-mail…
![](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(64, 76%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
0 answers
Question regarding Access
How do I add a location to the Company category?
asked 2023-02-13T18:31:13.21+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(38.4, 2%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Sandy Kehoe
0
Reputation points
asked 2023-02-13T18:31:13.21+00:00
Sandy Kehoe
0
Reputation points
1 answer
Design Access control in SSAS Tabular Model
Hi Everyone, I need some help to design the dynamic access control in SSAS tabular model. Below is the requirement: Row level security but access aggregate level data Using AD groups (AD groups contain the employee email address - UserId) Note: I…
asked 2023-02-07T17:42:26.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(272, 24%, 36%)' 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)
Manikant Mahovia
41
Reputation points
edited the question 2023-02-10T17:14:28.4466667+00:00
JamesTran-MSFT
36,531
Reputation points Microsoft Employee
0 answers
Change routing and remote access service port
How to change routing and remote access service port? Here is a similar article, but it is not for routing and remote access https://video2.skills-academy.com/en-us/previous-versions/windows/it-pro/windows-7/dd837646(v=ws.10)
asked 2023-02-10T11:41:06.72+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, 23%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENB%3C/text%3E%3C/svg%3E)
Nick B
361
Reputation points
edited the question 2023-02-10T11:44:23.6133333+00:00
GitaraniSharma-MSFT
49,256
Reputation points Microsoft Employee
0 answers
This problem just started - MS Access WILL NOT allow me to do a "save as" in a query.
This is my first post, so I'm open to being corrected if I did something wrong. A few facts and a disclaimer: I am older, retired and this is my personaI/home computer. I have been working with Microsoft Access since it first came out. However, I only…
asked 2023-02-09T22:23:34.11+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(156.8, 25%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDM%3C/text%3E%3C/svg%3E)
David Molica
5
Reputation points
asked 2023-02-09T22:23:34.11+00:00
David Molica
5
Reputation points
2 answers
Cannot access my work account or configure in Authenticator
I tried setting up my work account (onmicrosoft account) on my iPhone but was unsuccessful as I was asked to scan a QR code which I do not have nor can get. The work account on my desktop is now unaccessible as I am asked to verify Authenticator for…
asked 2023-02-08T14:17:33.33+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(25.6, 39%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGG%3C/text%3E%3C/svg%3E)
Gilles Gervais
5
Reputation points
answered 2023-02-09T11:54:32.3533333+00:00
Gilles Gervais
5
Reputation points
0 answers
Using filter by form in Access taking way longer than usual
We have Access with Microsoft 365 Apps for business as the frontend to SQL Server 2017. One of the forms in Access is routinely searched by using filter by form (Ribbon > Home > Sort & Filter > Advanced > Filter by Form). Now performing…
asked 2023-02-07T23:40:33.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(22.400000000000002, 75%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Kevin McCartney
0
Reputation points
edited a comment 2023-02-08T20:14:54.4233333+00:00
Kevin McCartney
0
Reputation points
1 answer
Major Issue with latest Current Channel update
I'm having a major issue relinking tables with the latest Current Channel rollout of Version 2212, Build 15928.20216. Trying to programmatically relink tables gives the error 3125-dbo.TableName is not a valid table name.
asked 2023-01-13T15:51:23.7133333+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(188.79999999999998, 50%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tracy Smith
15
Reputation points
commented 2023-02-07T20:24:56.3866667+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(0, 6%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Maria Barnes
11
Reputation points MVP
0 answers
To pull Access Control List for each group
As in this picture I want to pull detail "Permissions for" i.e. as like Read / Write / Create etc as like Allow / Deny for each Group or User name inside the Security TAB for any particular OU. (Get-ACL "AD:$((Get-ADOrganizationalUnit…
Windows
Windows
A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.
4,998 questions
Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
11,253 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
333 questions
asked 2023-01-13T08:59:11.5033333+00:00
Manas Dash
0
Reputation points
edited the question 2023-02-03T06:01:42.83+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(281.6, 17%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
Givary-MSFT
30,251
Reputation points Microsoft Employee
1 answer
How to give user to only access his user profile and block other all folders for him in windows 10
Anyone know how to give user to only access his user profile and block other all folders for him in windows 10
asked 2023-01-28T09:10:16.23+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, 20%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Janith Sahasra
6
Reputation points
edited the question 2023-01-30T01:17:43.5933333+00:00
Jack J Jun
24,491
Reputation points Microsoft Vendor
0 answers
How to restrict access to the inherited groups (management and subscription) access to the resources underneath it?
Hi, In the scenario where in the storage account is used to host a confidential data, how can we prevent the inherited subscription and management groups (with owner and contributor roles) access to the connection string of this new confidential…
asked 2023-01-26T13:47:18.75+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, 75%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sandhya Reddy Veera
21
Reputation points
asked 2023-01-26T13:47:18.75+00:00
Sandhya Reddy Veera
21
Reputation points