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…
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…
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…
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…
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) …
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 )
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…
How do I grant users access to my Cognitive Services dashboard?
How do I grant user access to my Cognitive Services dashboard?
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?
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…
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.
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…
DCountWrapper
I cannot find what Dcountwrapper is and the Northwind template uses this. Can anyone help?
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…
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…
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…
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…
I cannot login http://portal.azure.com/ of even submit a support request.
Hello. I cannot login [http://portal.azure.com/] of even submit a support request. I never use any LEGO cloud services and don't know why I am redirected to legogroup.onmicrosoft.com Video about this issue https://youtu.be/kUlomGxvucQ I am also unable…
That Account Doesn't Exist
I'm trying to move a Microsoft Access database to Azure SQL, and use an existing Access application to access the database. I created a user in Azure Active Directory, and gave it permission to read and update the database in SQL Management Studio. I…
Certain IP address unable to access sharepoint online
I have a client that has restricted access to his SharePoint Online tenant based on IP address. Everyone on the organization's network can access SharePoint Online without any issues. I am trying to access the SharePoint Online tenant remotely and my…