Access
A family of Microsoft relational database management systems designed for ease of use.
333 questions
1 answer
How to open the *.mdb files created in earlier version of Microsoft Access in
the file created in 2000 and the file name extension is *.mdb in older version of office 2K, not able to open in Microsoft Access 365
asked 2023-03-09T09:33:55.9766667+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, 77%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENH%3C/text%3E%3C/svg%3E)
Nandish Hosaguthi Hoovappa
0
Reputation points
edited an answer 2023-04-28T10:22:36.1166667+00:00
Tanay Prasad
2,115
Reputation points
3 answers
What is #Func! error message for in access? How to fix it?
I checked everything; there's no error with the formula. One thing I want to mention is I got #Func! Error for the vendors who had only one invoice with the amount of 0. Other vendors had multiple invoices with different amounts with the amount 0 and…
asked 2023-04-18T22:20:25.9266667+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(128, 8%, 22%)' 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)
Anonymous
answered 2023-04-28T10:19:26.0066667+00:00
Olaf Helper
42,761
Reputation points
0 answers
You’ve been suspended from Microsoft Q&A in Microsoft Community
Hello. Today, my access to the Microsoft Learn portal is restricted. It says closed for breaking the rules, please give me a definite explanation why my account was suspended. I do not deserve it. As someone who has served for Microsoft for years, who…
asked 2023-04-25T05:23:42.8333333+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, 55.00000000000001%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIS%3C/text%3E%3C/svg%3E)
Izmir Sadigov
0
Reputation points
edited a comment 2023-04-26T05:22:58.3+00:00
Izmir Sadigov
0
Reputation points
1 answer
Export More than 65,000 Records from Access Macro Query
Hi all, I am trying to export this query called Policy Snapshot. I have a macro that runs this query and outputs the file in a particular location. The last few times my team and I ran the query, we noticed that the query will not export more than…
asked 2023-04-20T17:34:14.1033333+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, 13%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMJ%3C/text%3E%3C/svg%3E)
McCullough, Julius
0
Reputation points
answered 2023-04-25T20:57:17.77+00:00
Ken Sheridan
2,756
Reputation points
1 answer
One of the answers was accepted by the question author.
Automate Access database to SQL server data load
Hi, My requirement is to load data from Access database, placed in Network drive to Azure SQL. I know there is option to use Data Factory but for that I need to install backdated Access ODBC driver in self hosted IR which is being blocked by security…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,343 questions
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,055 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,015 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
333 questions
asked 2023-04-25T07:34:02.7266667+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(236.8, 31%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPD%3C/text%3E%3C/svg%3E)
Pratim Das, Partha C
306
Reputation points
accepted 2023-04-25T14:59:09.1+00:00
Pratim Das, Partha C
306
Reputation points
0 answers
HELP: Call MsAccess 2019 from Task Scheduler, bar chart missing in pdf
We are migrating reports from MsAccess 2007 to MsAccess 2019. The report in Access has a dynamic bar chart; data changes based on which ID is passed in a bat file. In the database there are linked servers to Sql server that has the values for the chart…
asked 2023-04-25T07:01:40.5166667+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, 4%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA1%3C/text%3E%3C/svg%3E)
AccessRookie-1455
0
Reputation points
edited the question 2023-04-25T07:05:41.62+00:00
AccessRookie-1455
0
Reputation points
0 answers
Power Bi data evaluation (questions are described below)
1st question: I have 2 columns that I want to add together (Power A + Power B), I would like to display these in the line chart, unfortunately with Power BI I can only set: Maximum, Min, Count, Sum, Median, Variance etc, but I want to have the real value…
asked 2023-04-20T05:43:38.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(182.40000000000003, 84%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
real_Nik_Nak
0
Reputation points
commented 2023-04-20T06:53:59.7566667+00:00
Olaf Helper
42,761
Reputation points
6 answers
Next meeting for Access User Groups - Europe
The next Access Europe meeting will be on Wednesday 1 Feb 2023 starting at 18:00 (6PM) and finishing at about 19:30 (7.30PM) UK time (UTC) The start time is equivalent to 19:00 (7PM) in Central Europe / CET (UTC+1) and 10AM in Seattle / PDT (UTC-8) …
asked 2023-01-25T21:05:51.93+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(108.80000000000001, 90%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
Colin Riddington
141
Reputation points MVP
commented 2023-04-18T21:27:07.15+00:00
Colin Riddington
141
Reputation points MVP
0 answers
Actually I am not professional in using microsoft expression web 4 , I am using it on windows 11 , the problem is when I try to connect an ASPX connection but there is a pop up problem message says that the web.config page got errors so what should I do ?
the error massege is : ( Connection information could not be stored in the web application configuration file (web.config) due to errors in the file . Fix the errors and try again )
asked 2023-04-12T10:31:11.84+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(300.8, 72%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Sara Ali
0
Reputation points
commented 2023-04-13T07:06:07.0433333+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, 4%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQM%3C/text%3E%3C/svg%3E)
QiYou-MSFT
4,311
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Cost of moving from Access to .Net
My company has a fairly complicated Microsoft Access Front End and a SQL Server Back End application which is mission critical to our operations. Since Microsoft has not provided any support to Access for sometime, the higher-ups are getting anxious…
![](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, 61%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
1 answer
How do I grant users access to my Cognitive Services dashboard?
How do I grant user access to my Cognitive Services dashboard?
asked 2023-04-07T02:04:36.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(288, 67%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
John
10
Reputation points
commented 2023-04-11T22:09:17.4966667+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, 4%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVM%3C/text%3E%3C/svg%3E)
VasaviLankipalle-MSFT
15,836
Reputation points
0 answers
If is stop using Project Online (PWA) can I still access the project sites?
We are considering discontinuing the use of Project Online (PWA) which currently generates a SharePoint site for each project - will we still be able to access these sites if we decommission PWA?
![](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, 27%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
0 answers
MS Graph 8 in Access 365 resize problem display resolution or windows depending
I have a simple MS Chart Object on a form in a sample database to avoid any other problem. If opening database in Windows 10 on 100 % screen resolution 2560 * 1440 Chart fills out all size of object placeholder (left in picture). Same database on Windows…
asked 2023-01-18T08:06:04.6166667+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(137.6, 95%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWO%3C/text%3E%3C/svg%3E)
Wolfram Oldörp
0
Reputation points
edited the question 2023-04-10T10:32:34.22+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(121.6, 46%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGC%3C/text%3E%3C/svg%3E)
Gopinath Chennamadhavuni
2,431
Reputation points
1 answer
Using a List of employees to open report
I would like to open a report based on the selection from a list of employees. Can this be done? IF so, please assist.
![](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(166.4, 27%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI%3C/text%3E%3C/svg%3E)
0 answers
No work or school account listed, yet still being tracked by enterprise software from ex-employer
Hi, I seem to have enterprise software on my computer that tracks my work, logs my files, etc. There seems to be some Azure and MDM software that's tracking my activity even though I'm using a personal account on my personal device that was never…
asked 2023-04-04T10:30:44.0666667+00:00
Anonymous
edited the question 2023-04-04T10:50:55.6866667+00:00
Anonymous
0 answers
DCountWrapper
I cannot find what Dcountwrapper is and the Northwind template uses this. Can anyone help?
1 answer
Some users cannot connect to Azure SQL Servre from Access
We have set up an Azure SQL Server database. We're trying to use an Access database as the front end, using Azure Active Directory authentication. We've got one user connecting without any issues (the one that created the SQL Server database and Access…
asked 2023-03-09T14:16:52.5266667+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, 24%, 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)
Jen Phillips
0
Reputation points
commented 2023-03-31T17:25:34.0433333+00:00
JamesTran-MSFT
36,531
Reputation points Microsoft Employee
2 answers
System.Data.OleDb.OleDbException: 'Syntax error in UPDATE statement.'
Hello, I am having an issue saving/updating my database using Access in C#. If anyone is able to help solve my issue it would be greatly appreciated. Thank you! Here are the details: System.Data.OleDb.OleDbException HResult=0x80040E14 Message=Syntax…
asked 2023-03-24T14:10:15.34+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(150.4, 76%, 24%)' 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)
Andrew Klasen
1
Reputation point
edited a comment 2023-03-29T09:43:57.6166667+00:00
Karen Payne MVP
35,291
Reputation points
1 answer
On Win11Pro 64-bit ARM, Visual Studio 2022 cant connect to MS Access (all 64-bit)
I always get the "Microsft.ACE.OLEDB.12.0 provider is not registered on the local machine" error (see the attached screen capture). When trying to configure the ODBC admin I get the 193 error "the setup routine ODBC driver could not be…
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-03-18T18:41:38.55+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, 48%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAZ%3C/text%3E%3C/svg%3E)
Amit Zuker
0
Reputation points
commented 2023-03-28T09:19:43.61+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
1 answer
Access App Crashes
Hi - I have an access app (sql server backend) deployed for several (30+) clients all over the midwest. Each client has one pc dedicated to running some backend tasks (pulling from other sql servers, sending emails, importing and storing info from text…
![](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(48, 60%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)