SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,217 questions
2 answers
Microsoft Access 365 with SQL 2019
Dear Support Team, One of our customer is using Microsoft Access 365 with SQL 2012 and we wanted to check if Microsoft access 365 is compatibility with SQL Server 2019. Thank you for the help in advance. Regards, Syed
asked 2023-05-24T13:14:22.9+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, 6%, 26%)' 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)
Kazim Mohammed Razvi
0
Reputation points Microsoft Employee
commented 2023-05-28T10:16:19.4866667+00:00
Kazim Mohammed Razvi
0
Reputation points Microsoft Employee
3 answers
One of the answers was accepted by the question author.
MS ACCESS how to allow an insert option for the text box?
In MS Access, when right click on the text box, an Insert option is grayed out. Is there a way to enable this option for inserting an image in the text box? Thank you for your time.
asked 2023-05-23T11:53:31.7+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, 60%, 12%)' 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)
Jack Panyakone
25
Reputation points
commented 2023-05-24T18:17:15.15+00:00
Jack Panyakone
25
Reputation points
3 answers
How to fix cost Management App connection to my data
I am unable to connect my data to cost management app even after providing the enrolment number. Is it something to have with the access level which my account holds or is it something to have with the storage account credentials or secret keys for…
asked 2023-01-12T11:38:14.22+00:00
Shubham Jaiswal
1
Reputation point
answered 2023-05-24T09:16:48.8633333+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, 31%, 24%)' 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)
Adam313
11
Reputation points
0 answers
Request for information on using the idQ attribute for custom ribbons in Access.
Hello, I am looking for detailed information to understand the use of idQ attribute with custom ribbon in Access. Following tests, I note for example that there are differences in display behavior when 2 ribbons share controls (idQ) between 2 forms with…
asked 2023-05-20T16:37:18.2866667+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 a comment 2023-05-24T07:56:31.5933333+00:00
jacky Perpète
41
Reputation points
0 answers
You have requested code too many times today. Please try again tomorrow.
this message was poping out yesterday and i tryed today and it was not working.do i need to wait for 24 hours for this to be canceled or i need to do other things
asked 2023-05-15T02:12:32.3633333+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(19.2, 50%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
he meng
0
Reputation points
edited the question 2023-05-22T06:17:20.6366667+00:00
Sumarigo-MSFT
44,996
Reputation points Microsoft Employee
1 answer
How can I fix this ODBC error?
I am trying to run a code that would update a table on an sql server. When doing this, I get an error seen below. Ive tried relinking the tables from the SQL server and they are all good so Im not sure what the error is.
asked 2023-05-19T17:47:25.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(70.4, 15%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELA%3C/text%3E%3C/svg%3E)
Lopez, Ahiezer
236
Reputation points
edited an answer 2023-05-22T05:50:24.2366667+00:00
Tanay Prasad
2,115
Reputation points
2 answers
This problem, 'Data type mismatch in criteria expression.', has been giving me problems
This is my code and I'm not sure what's wrong Dim strsql As String strsql = "Insert into Tbltenants (id,housenumber,lastname,firstname,phonenumber,email,term,payment_by,rent_paid)…
Windows Forms
Windows Forms
A set of .NET Framework managed libraries for developing graphical user interfaces.
1,869 questions
ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,397 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
333 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,644 questions
asked 2023-05-11T00:22:11.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(140.8, 12%, 23%)' 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)
DeBoss241
0
Reputation points
commented 2023-05-18T08:20:03.9833333+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,151
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
I published an App containing four reports (the users were granted access to all the reports). However, I got feedback from the users that they were able to access all three but the last one report in the App. How can I solve this issue?
I published an App containing four reports (the users were granted access to all the reports). However, I got feedback from the users that they were able to access all three but the last one report in the App. How can I solve this issue?
![](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(291.2, 6%, 38%)' 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)
2 answers
SQL View not returning correct records
I created a simple view that returns data from 2 tables: a master table with the PK an Int, Identity Specification and the detail table with the FK an Int The tables are Inter Joined PF to FK When I display the view in Access it displays the data from 1…
asked 2023-05-15T21:05:48.9466667+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(44.800000000000004, 89%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBV%3C/text%3E%3C/svg%3E)
Bob Vitter
181
Reputation points
answered 2023-05-16T15:26:05.5433333+00:00
Bob Vitter
181
Reputation points
1 answer
New forms aren't saving to Access database.
Microsoft Access is seemingly allowing me to save forms to our database, but when I look at the table, it has not been saving each form. For the last few weeks, it has only been saving the most recent two forms, and it seems like the ones saved before…
asked 2023-05-02T18:11:49.1133333+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(172.8, 39%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Abby Koop
0
Reputation points
edited an answer 2023-05-12T03:56:09.9966667+00:00
Tanay Prasad
2,115
Reputation points
2 answers
I am getting a compile error when trying to open up my database in access
the code in this project must be updated for use on 64-bit systems. please review and update declare statements and then mark them with the PtrSafe attribute I have no idea what they want me to do or how to fix it.
asked 2023-05-10T18:12:25.98+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, 83%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETR%3C/text%3E%3C/svg%3E)
Tanya Rothstein
0
Reputation points
edited an answer 2023-05-11T07:11:00.8733333+00:00
Tanay Prasad
2,115
Reputation points
1 answer
Couple Access files not opening on 1 PC, just give spinning circle
SO I have been trying to find a solution that a few users are having on 1 PC. There are 4 older Access files (.mdb) on the network drive and when they open them and print the report from them then try and open the next one, they just get a spinning…
asked 2023-05-09T19:15:05.73+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, 10%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jesse Hendryx
0
Reputation points
answered 2023-05-11T07:00:07.59+00:00
Tanay Prasad
2,115
Reputation points
1 answer
One of the answers was accepted by the question author.
MS Access 2019 SQL INSERT long parameter error
Upgraded PC and MS Office. Using MS Access 2019 MSO (Version 2304 Build 16.0.16327.20200) 32 bit on a Windows 11 Pro computer 10.0.22621 Build 22621 x64-based PC Create a Simple access database Data.accdb containing the table Table1 with the…
asked 2023-05-08T18:59:51.7666667+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(51.2, 6%, 14%)' 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)
Jim Longlade
20
Reputation points
commented 2023-05-09T12:53:01.13+00:00
Jim Longlade
20
Reputation points
1 answer
How to fix error 0x80071771
i just reseted my pc and loaded 1 file on a usb stick then i pluged in the usb and it said that i couldn't copy it and that my access was denied i have tried everything and when i go to properties security does not appear please help i am a cartoon…
asked 2023-05-01T13:28:47.1433333+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(291.2, 82%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGT%3C/text%3E%3C/svg%3E)
geo thed
0
Reputation points
answered 2023-05-09T09:13:21.46+00:00
Tanay Prasad
2,115
Reputation points
0 answers
Need to create a linked table to an Excel spreadsheet that has an internet address. I receive the error "Only XML files can be imported from an internet address.
https://social.technet.microsoft.com/Forums/office/en-US/2cc4905e-a8f7-437e-921a-88843354bce5/need-to-create-a-linked-table-to-an-excel-spreadsheet-that-has-an-internet-address-i-receive-the?forum=sharepointgeneral The post in the link above seems to…
asked 2023-04-06T22:07:39.92+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(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' %3EM%3C/text%3E%3C/svg%3E)
MIKEsonOFbob
5
Reputation points
commented 2023-05-08T22:57:33.14+00:00
MIKEsonOFbob
5
Reputation points
2 answers
In VBA, reference the values of control properties defined in Design mode when in Run mode.
Hello, Is it possible in VBA, to reference the values of control properties defined in Design mode when in Run mode? Example of simple use: If I set the font color value of a textbox to red in design mode, I want in run mode to be able to reposition that…
asked 2023-05-05T08:28:10.8033333+00:00
jacky Perpète
41
Reputation points
commented 2023-05-05T12:39:16.7433333+00:00
jacky Perpète
41
Reputation points
0 answers
You're not eligible for an Azure free student account
I'm getting 'You're not eligible for an Azure free account' error when I'm a student and signed in from my university email. I'm from Sri Lanka having a UK university email. Am I not eligible?
asked 2023-05-05T09:53:14.1333333+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, 82%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPI%3C/text%3E%3C/svg%3E)
Piyara Induwarie Vishwaja Wijewardhana
10
Reputation points
asked 2023-05-05T09:53:14.1333333+00:00
Piyara Induwarie Vishwaja Wijewardhana
10
Reputation points
1 answer
Manage access in Sharepoint
Hi Team, I am having issues with SP access. We have 2 types of users owner and the members, we have selected for members to have editing access where they can update cells in our SP data base however they seem to not be able to do and the only way they…
asked 2023-05-01T21:58:01.7833333+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(198.4, 92%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOO%3C/text%3E%3C/svg%3E)
Ozzie O Menay
0
Reputation points
commented 2023-05-05T08:40:11.4766667+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
43,661
Reputation points Microsoft Vendor
4 answers
One of the answers was accepted by the question author.
How to fix "Run-time error '3012': Object 'MyQuery' already exists"
Hi everyone, I was trying to update some information on the database using Form and suddenly I got an error message saying, "Run-time error '3012': Object 'MyQuery' already exists". It was working perfectly fine before till now. I have a little…
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
333 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,644 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
![](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, 63%, 39%)' 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)
1 answer
Identity Governance
I am getting the error "Tenant does not meet license requirements. Correlation ID" When the user is requesting access packages. What might be the problem?
asked 2023-04-30T05:37:35.88+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(51.2, 31%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETM%3C/text%3E%3C/svg%3E)
Talente Mathabathe
0
Reputation points
answered 2023-04-30T14:29:24.71+00:00
Vasil Michev
99,661
Reputation points MVP