Azure SQL Database
An Azure relational database service.
5,123 questions
1 answer
ODBC Connection DSN and Linked Table Manager Giving Different Results: The link table manager in access database only gives the master tables
I am setting up a DSN and a Linked Table Manager link all on the same Access database on the same computer with the same database Login and associated User (and of course the same database). The DSN gives me the tables I need, but the Linked Table…
asked 2024-04-23T20:44:30.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(182.40000000000003, 50%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
EFS
0
Reputation points
edited the question 2024-04-25T16:43:17.91+00:00
Oury Ba-MSFT
16,081
Reputation points Microsoft Employee
0 answers
Access Europe User Group Meeting - Using VBA to create a class based on a table - Wed 1 May
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some…
asked 2024-04-24T20:46:35.66+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
146
Reputation points MVP
edited the question 2024-04-24T21:00:50.91+00:00
Colin Riddington
146
Reputation points MVP
0 answers
When I select the Lookup Wizard option in Access, I encounter Path Not Found
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,746 questions
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,303 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
304 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.
821 questions
asked 2024-04-23T18:08:38.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(89.60000000000001, 38%, 18%)' 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)
سید محمد صابر موسوی
0
Reputation points
edited the question 2024-04-24T02:30:42.0733333+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
27,886
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Execution Context for MS Access front end to SQL Server backend
Hello, we have a business application that is based on MS Access front end and SQL Server backend. Tables are linked via DNS-less connection. The application is using SQL Server Authentication using an ODBC connection, driver is SQL Server (connection…
![](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, 96%, 11%)' 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
I cannot see any tables when Connecting the Azure via MS Access Linked Table Manager, what am I missing?
I have installed AdventureWorksLT as well as my own tables in a new Azure database that I am trying to connect to via "Linked Table Manager" in MS Access but all I see are the sys tables. If I use DoCmd.TransferDatabase acLink it works fine…
asked 2024-04-22T17:41:46.8033333+00:00
EFS
0
Reputation points
answered 2024-04-23T05:30:18.2566667+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, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
13,271
Reputation points Microsoft Employee
3 answers
Working with Access database via OleDbReader
Hey all I have no problem when all my access mdb are string! I'm using Access database engine 2010 to connect to mdb. The problem occurs when I have Boolean / Integer / Date fields: New OleDbCommand("INSERT INTO tableblah (strfield, intfield,…
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,245 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,569 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.
821 questions
asked 2024-04-01T16:00:49.7066667+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(12.8, 77%, 11%)' 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)
StewartBW
260
Reputation points
commented 2024-04-19T09:41:12.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(64, 85%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJX%3C/text%3E%3C/svg%3E)
Jiale Xue - MSFT
31,971
Reputation points Microsoft Vendor
1 answer
Access crashes when mouse pointer enters specific criteria field cell
I've got a database with a number of similar group by queries, each using the Format function on a date field. Just by getting the mouse pointer in the criteria row of that particular field in design view, the database crashes, consistently, without…
asked 2024-04-13T02:19:08.58+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(48, 78%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWG%3C/text%3E%3C/svg%3E)
Wayne Gunn
1
Reputation point
edited an answer 2024-04-15T11:27:32.3066667+00:00
Karl Donaubauer
1,646
Reputation points MVP
0 answers
Client providing access to their sharepoint and I have been blocked as a risk
I am not a technical person. I am a solopreneur. Today my client provided access to their sharepoint and I was blocked in Microsoft as a risky user. I have been into the DNS to find out if there is something there I should change, now I am in Azure to…
asked 2024-04-04T13:35:15.44+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(304, 92%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Mel Ross
0
Reputation points
commented 2024-04-13T02:26:43.48+00:00
Shawn Collins
265
Reputation points
2 answers
One of the answers was accepted by the question author.
ADD Column will not show CheckBox
Hello, Using Access database engine + oledbreader on mdb, this code will add a new boolean yes/no column: New OleDbCommand("ALTER TABLE BlahTable ADD Column BlahOption BIT NOT NULL", strConnection) :: ExecuteNonQuery This will add a yes/no…
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,245 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,569 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.
821 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,000 questions
asked 2024-04-03T02:01:31.49+00:00
StewartBW
260
Reputation points
commented 2024-04-12T20:43:06.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(262.40000000000003, 46%, 35%)' 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)
Albert Kallal
4,651
Reputation points
2 answers
One of the answers was accepted by the question author.
Office Access Refactoring
Hey, In our company we've a legacy software based on Office Access. We have access to the accdb-File with all sources. This software is connected to a SQL-Server Database. We want to tidy up our database therefore we need to now which columns are used by…
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.
821 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,000 questions
asked 2024-04-09T14:07:03.8+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, 94%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFR%3C/text%3E%3C/svg%3E)
Fabig, Richard
20
Reputation points
edited the question 2024-04-12T00:40:06.8366667+00:00
Emi Zhang-MSFT
21,856
Reputation points Microsoft Vendor
1 answer
Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former Access MVP, Dale Fye who will be discussing working with…
asked 2024-03-26T09:27:15.27+00:00
Colin Riddington
146
Reputation points MVP
answered 2024-04-08T15:03:59.72+00:00
Colin Riddington
146
Reputation points MVP
1 answer
Connection string working for WinForm but not working for asp.net
Hi In a net framewok WinForm app below connection string works in x86 and Any CPU active platforms. connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Password=;User ID=Admin;Data Source=' S:\MyPath\MyDB.mdb';Mode=Share Deny None;" However in…
![](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(304, 15%, 39%)' 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)
1 answer
Database version
Hey everyone This wiki table is referiong to different Access ACE database versions: https://en.wikipedia.org/wiki/Access_Database_Engine ie ACE 14 supports database version 3.x and 4.0 ACE 15 and 16 only support database version 4.0 My question is that…
asked 2024-03-30T19:40:55.6066667+00:00
StewartBW
260
Reputation points
commented 2024-04-01T22:04:31.29+00:00
Albert Kallal
4,651
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.
304 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,569 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.
821 questions
1 answer
Microsoft Teams chat
Hello, I have one question for you. I don't know that is work or not But i just want to know. Now we created the teams chat group and add the all office department members for IT Help Desk issues. At that time, one of member from marketing dept(eg:) send…
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.
3,783 questions
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
9,070 questions
Microsoft Deployment Toolkit
Microsoft Deployment Toolkit
A collection of Microsoft tools and documentation for automating desktop and server deployment. Previously known as Microsoft Solution Accelerator for Business Desktop Deployment (BDD).
828 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.
821 questions
Microsoft Teams Phone
Microsoft Teams Phone
Teams Phone enables call-control and Private Branch Exchange (PBX) capabilities in the Microsoft 365 cloud with Microsoft Teams.
119 questions
asked 2024-03-15T07:10:29.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(188.79999999999998, 11%, 28%)' 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)
IT Support
266
Reputation points
commented 2024-03-29T05:28:42.8433333+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, 49%, 37%)' 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)
LiweiTian-MSFT
13,990
Reputation points Microsoft Vendor
1 answer
How do I change validation rules in Access when I can't find the original table?
Please excuse my ignorance...I have not had the need for Access for five years. I have a data input table that was designed to make it easy for data entry, with form view, design view, and datasheet view. When entered, the data can be seen in the Data…
asked 2024-03-16T23:00:02.1833333+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, 48%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
Dan Boyle
0
Reputation points
answered 2024-03-27T12:53:19.9166667+00:00
Ken Sheridan
2,666
Reputation points
2 answers
how to format ms access dates with odbc data source
M365 Access App FE on PC win 11 - SQL Server Express back end on server. Can't format dates in form txt controls bound to appropriate date field from BE.
asked 2024-03-20T14:07:09.7366667+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(310.4, 49%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENC%3C/text%3E%3C/svg%3E)
Nick Coe
0
Reputation points
answered 2024-03-21T18:09:10.0133333+00:00
Albert Kallal
4,651
Reputation points
0 answers
Why am I receiving this Error - Records in table <name> would have no record on the 'one' side.
All of a sudden my Access Query is giving me the error - Records in table <name> would have no record on the 'one' side. Works on my Laptop doesn't work on Clients Laptop!
asked 2024-03-18T04:49:35.5033333+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(275.2, 32%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJF%3C/text%3E%3C/svg%3E)
John Fields
0
Reputation points
edited a comment 2024-03-19T20:53:12.0133333+00:00
Viorel
112.1K
Reputation points
1 answer
How can we automate snipping tools through VBA?
Hi everyone! Im trying to automate the Sniping Tool Windows 11 and to use his OCR feature. Somebody knows how can I get it?
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,463 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,488 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.
821 questions
asked 2024-03-18T11:03:35.4366667+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(284.8, 49%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Alessandro Pereira
0
Reputation points
answered 2024-03-19T15:46:19.4466667+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(307.2, 44%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
Claudia Dos Santos Haz (CONCENTRIX CORPORATION)
695
Reputation points Microsoft Vendor
0 answers
Outlook saveas did not save the embedded image added from vba or build manually
Hi folks, We run a vba code that create email using data from an Acess database. We add some picture using html format for the email and save it in Outlook format(msg) to read them later. When I display it, we see the image inside the email. After using…
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,488 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.
821 questions
asked 2024-03-18T12:10:11.8433333+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(64, 28.000000000000004%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Simon G364
0
Reputation points
asked 2024-03-18T12:10:11.8433333+00:00
Simon G364
0
Reputation points