40 questions with Access tags

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

External users without Microsoft account cannot access Sharepoint site

Hello, I have created a Sharepoint site within my organization, and within it I have created a series of folders and files to share with external people (I have enabled external sharing to users who do not belong to the organization, etc.). The problem…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
326 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,103 questions
asked 2024-06-18T10:55:17.8066667+00:00
SAT TECH 20 Reputation points
answered 2024-06-20T13:53:33.4866667+00:00
Mustafha Shariff 0 Reputation points
3 answers One of the answers was accepted by the question author.

Limit the rows in Access table

Hello Is it possible to limit the number of rows in each Access mdb database table? Will need to apply the limitation via VB.NET OLEDB and using Access database engine. Thanks.

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
326 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,640 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.
847 questions
asked 2024-06-13T15:00:50.7033333+00:00
StewartBW 745 Reputation points
answered 2024-06-15T14:13:18.4+00:00
Ken Sheridan 2,756 Reputation points
6 answers One of the answers was accepted by the question author.

Invalid procedure call or argument error

When pressing a command button the code below is executed, and it results in an error as seen in the picture. In addition, I seem to be the only user with this issue. My coworkers don't mention having this issue. I never had this issue until about a…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
326 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.
847 questions
asked 2024-06-04T21:28:57.5766667+00:00
Lopez, Ahiezer 236 Reputation points
accepted 2024-06-12T18:28:09.0066667+00:00
Lopez, Ahiezer 236 Reputation points
2 answers One of the answers was accepted by the question author.

access copy and paste issue

We have a strange intermittent issue in an Access 2016 database application (classic architecture with individual front end per user with links to a central backend database), that prevents users copying text from emails, word docs, xlsx spreadsheets etc…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,427 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
326 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,671 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.
847 questions
asked 2024-03-08T08:21:54.9866667+00:00
crib bar 781 Reputation points
accepted 2024-06-03T11:58:50.84+00:00
crib bar 781 Reputation points
1 answer One of the answers was accepted by the question author.

How can I have such a result from two tables? With SQL command

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,639 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
326 questions
asked 2024-03-12T04:44:19.1833333+00:00
Mansour_Dalir 1,676 Reputation points
accepted 2024-04-16T04:42:29.2266667+00:00
Mansour_Dalir 1,676 Reputation points
2 answers One of the answers was accepted by the question author.

mdb/accdb to use with Access database engine

Hey I need to create an Access database in Office Access and make the tables and fields, then deliver the blank file with the vb.net app which will use Access database engine 2010 and OleDbRerader to work with the database. Just need to decide between…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
326 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,640 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.
847 questions
asked 2024-03-28T13:53:33.89+00:00
StewartBW 745 Reputation points
accepted 2024-03-29T10:53:40.9166667+00:00
StewartBW 745 Reputation points
1 answer One of the answers was accepted by the question author.

Special characters can't be used in password files UAC

We created the most elaborated password for our domain admin account with a lot of special characters, the first laptop with windows 11 pro and we directly found a ""bug"". The UAC from win 11 will automatically try to incorp special…

Windows Server 2019
Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
3,557 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
326 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,492 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
8,732 questions
asked 2023-05-22T13:31:44.04+00:00
beheer Lorreine 20 Reputation points
commented 2024-03-18T13:43:20.85+00:00
Van Hallman 0 Reputation points
3 answers One of the answers was accepted by the question author.

summary report for blank values per field in access

We have a large table of data (several thousand records), and a significant amount of fields is recorded for each record. The design of the table means at present some fields are mandatory (required), and others are not required – which I think was…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,427 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
326 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.
847 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,055 questions
asked 2024-03-11T12:58:39.2+00:00
crib bar 781 Reputation points
edited the question 2024-03-18T08:13:02.63+00:00
Emi Zhang-MSFT 23,271 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

How to filter a table with SQL command and get the result in another table?

MainTable from to cTag Signal A B T_AtoB x_1 A B T_AtoB x_2 A B T_AtoB x_3 A B T_AtoB x_4 B A T_AtoB x_1 B A T_AtoB x_2 B A T_AtoB x_3 B A T_AtoB x_4 C F T_CtoF x_1 C F T_CtoF x_2 C F T_CtoF x_3 C F T_CtoF x_4 C F T_CtoF x_5 F C T_CtoF x_1 F C T_CtoF x…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,639 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
326 questions
asked 2024-03-11T15:32:18.1566667+00:00
Mansour_Dalir 1,676 Reputation points
accepted 2024-03-11T16:04:23.63+00:00
Mansour_Dalir 1,676 Reputation points
1 answer 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!

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
326 questions
asked 2024-01-26T18:04:32.2033333+00:00
Brenda Edders 25 Reputation points
commented 2024-02-28T21:57:58.1+00:00
Marciniak, Timothy (MNIT) 0 Reputation points
1 answer One of the answers was accepted by the question author.

access denied shared database

sometimes in the access front end with linked tables, I get a message: ... [path to data table]file already in use, how do I limit those errors?

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
326 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,055 questions
asked 2024-02-07T18:08:38.4766667+00:00
Karen L. Miller 20 Reputation points
edited the question 2024-02-22T06:23:13.89+00:00
Emi Zhang-MSFT 23,271 Reputation points Microsoft Vendor
3 answers One of the answers was accepted by the question author.

Problem with access inheritance between Storage Account and SMB File Shares

Hello, I need to grant access to only 1 SMB File share and keep other SMBs inside Storage Account inreachable for specific user, but I have no idea how to do it or is it even possible. I tried granting Contributor access to one SMB, but user wasn't even…

Azure Files
Azure Files
An Azure service that offers file shares in the cloud.
1,207 questions
Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,852 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
326 questions
asked 2024-02-16T15:40:05.5366667+00:00
Michalaz 20 Reputation points
accepted 2024-02-21T09:48:09.4033333+00:00
Michalaz 20 Reputation points
1 answer One of the answers was accepted by the question author.

How to connect an Access 2010 database to a SQL Server database on a seperate computer

Hi All: I have a Microsoft SQL Server database stored on a separate computer MRM-WINX-002. I wish to create a Microsoft Access 2010 frontend (GUI) and have it link to the selected database on the server computer. Does anyone have illustrated Step-by-Step…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,162 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
326 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.
847 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,055 questions
asked 2024-01-19T15:33:23.1466667+00:00
Mark McCumber 431 Reputation points
edited the question 2024-01-23T07:49:20.8433333+00:00
Emi Zhang-MSFT 23,271 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

How to correct size of record navigation bar in Microsoft 365 version of Access that does not show lower one-third of bar at bottom of every record view?

Attached screen shots show the record navigation bar at the bottom of views of two examples from active data bases. The diminished bar appears in all Tables and Forms. Of course, Reports do not include the bar. Frequent users can learn to overcome this…

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
4,183 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
326 questions
asked 2023-04-29T16:08:28.1133333+00:00
Miles Gentry 25 Reputation points
commented 2024-01-11T17:38:12.93+00:00
Miles Gentry 25 Reputation points
2 answers One of the answers was accepted by the question author.

Error - Requested session access is denied

I'm having trouble logging into my virtual machine using an authorized local user account with all the necessary permissions. I keep receiving the error message "The requested session access is denied". However, I am able to log in successfully…

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,442 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
326 questions
Remote Desktop
Remote Desktop
A Microsoft app that connects remotely to computers and to virtual apps and desktops.
4,356 questions
asked 2023-07-05T15:30:52.96+00:00
Megha Goushal 25 Reputation points
commented 2023-12-27T13:14:13.54+00:00
Nikola M 0 Reputation points
1 answer 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…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
326 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.
847 questions
Microsoft 365 Publishing
Microsoft 365 Publishing
Microsoft 365: Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line. Publishing: The process of preparing, producing, and releasing content for distribution or sale.
604 questions
asked 2023-11-22T14:21:09.4966667+00:00
wire_jp 206 Reputation points
commented 2023-12-03T11:38:45.1166667+00:00
wire_jp 206 Reputation points
1 answer One of the answers was accepted by the question author.

Table in local emulator with CapsLock in table name is can't access by postman

I create 2 table with name are (Test, test) , I can access table test by using SAS key but Test I get no permission. you can check following picture

Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,852 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
326 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.
847 questions
asked 2023-11-20T06:29:13.9033333+00:00
Felix Truong 40 Reputation points
accepted 2023-11-27T14:32:42.85+00:00
Felix Truong 40 Reputation points
1 answer One of the answers was accepted by the question author.

How can I resolve the 'Cannot find user or service principal in graph database' error when assigning a role in Azure Digital Twins using a Microsoft account email?

I'm attempting to do the Digital Twins hands-on lab from GitHub (https://github.com/Azure-Samples/digital-twins-samples/tree/main/HandsOnLab), and I need to assign the Azure Digital Twins Data Owner permission using the following code: plaintextCopy…

Azure Digital Twins
Azure Digital Twins
An Azure platform that is used to create digital representations of real-world things, places, business processes, and people.
224 questions
Azure Role-based access control
Azure Role-based access control
An Azure service that provides fine-grained access management for Azure resources, enabling you to grant users only the rights they need to perform their jobs.
704 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
326 questions
asked 2023-11-24T08:16:51.2633333+00:00
hwajeong lee 25 Reputation points
commented 2023-11-25T09:46:02.41+00:00
hwajeong lee 25 Reputation points
1 answer One of the answers was accepted by the question author.

I have 2 MCID Account, I need to merge them as 1

Hello, I just realized I got 2 MCID created with different emails, I need help making this as just one. I just passed a Microsoft certification in one and I want that deleted while migrating the Exam to the other one I want to retain. Please let me know…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
326 questions
asked 2023-07-02T08:58:50.66+00:00
'Bayo Adegun 20 Reputation points
commented 2023-11-10T04:04:46.5766667+00:00
Rajeshwari Kurhade 0 Reputation points
3 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 Office Online Server
Microsoft Office Online Server
Microsoft on-premises server product that runs Office Online. Previously known as Office Web Apps Server.
611 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
326 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,103 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,055 questions
asked 2023-07-24T11:26:34.7566667+00:00
Antonio Tudela 71 Reputation points
answered 2023-11-09T12:32:40.2566667+00:00
Asem Wagih 5 Reputation points