Access
A family of Microsoft relational database management systems designed for ease of use.
317 questions
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
![](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
25
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
14,091
Reputation points Microsoft Employee
1 answer
#Func! Error I can’t get around
I have a column of data ([Premium Hdr].[Rev]) that contains blanks, letters and strings containing letters+numbers. I need to do a Nz on the blanks, trim the + and numbers if they are there, and if there are just letters, return that in a calculated…
asked 2024-04-21T02:34:58.9933333+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, 62%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERC%3C/text%3E%3C/svg%3E)
Ryan Chadwick
0
Reputation points
answered 2024-04-22T15:10:45.9866667+00:00
Ryan Chadwick
0
Reputation points
2 answers
where can I find Microsoft.ACE.OLEDB.12.0 Provider 64-bit
hello, We need the driver "Microsoft.ACE.OLEDB.12.0 Provider 64-bit", but it is no longer available! Could you provide me with a download link? Regards
asked 2024-04-19T01:28:50.96+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, 68%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEK%3C/text%3E%3C/svg%3E)
Elham Khalaji
0
Reputation points
answered 2024-04-19T05:55:04.49+00:00
Olaf Helper
42,286
Reputation points
0 answers
External Partner cannot access SharePoint
I have a group of external partners that need access to some SharePoint site and although they have been added to Azure they still cannot access the sites, I have removed and re-added them all seems to fail.
asked 2024-04-17T15:09:29.4+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, 26%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBY%3C/text%3E%3C/svg%3E)
Boyd, Yvonne
0
Reputation points
commented 2024-04-17T22:22:41.4433333+00:00
Andrew Geddes
741
Reputation points
1 answer
One of the answers was accepted by the question author.
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
Using FollowHyperlink not working
Have this code on a command button on a form. The field PDFName is also on the form. The filepath comes up OK. However, the line "Application.followhyperlink filepath,1,0" gives an error: RunTime Error 490; Cannot open the specified file."…
asked 2024-04-10T19:26:24.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(214.4, 84%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMN%3C/text%3E%3C/svg%3E)
Maxine Nietz
1
Reputation point
answered 2024-04-10T20:59:12.8166667+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(256, 41%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETV%3C/text%3E%3C/svg%3E)
Tom van Stiphout
1,701
Reputation points MVP
2 answers
Database Access issue
Hi I just wondering if you have time to help me with my Database Access issue. The problem is we have already a Database of complaints but when we try to open it there is a message attached here for your information and assistance.
asked 2024-04-10T03:26:01.8733333+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(25.6, 83%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Mereki Aneri
0
Reputation points
answered 2024-04-10T09:16:25.4933333+00:00
ShaktiSingh-MSFT
14,091
Reputation points Microsoft Employee
0 answers
ActiveX Control for Adobe PDF Reader not working
I have now posted this issue 3 times with no response. What's up with that !!!! Access 365 I have a form "ViewPDFForm" that has an ActiveX control named "ActiveXCtl2." It is an Adobe PDF Reader control. However, I cannot get it to…
asked 2024-04-09T21:14:49.2266667+00:00
Maxine Nietz
1
Reputation point
asked 2024-04-09T21:14:49.2266667+00:00
Maxine Nietz
1
Reputation point
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
![](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
answered 2024-04-08T15:03:59.72+00:00
Colin Riddington
141
Reputation points MVP
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
![](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
565
Reputation points
commented 2024-04-01T22:04:31.29+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
5,056
Reputation points
0 answers
como excluir minha conta
eu gostaria de excluir minha conta, mas aparece este erro:
asked 2024-03-29T21:26:20.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(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
asked 2024-03-29T21:26:20.49+00:00
Anonymous
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.
317 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,614 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.
841 questions
1 answer
How do I delete people's edit permissions?
I am trying to manage the access to a folder on sharepoint and I need to remove the edit access for some people. It seems I am not allowed to do it. (I and the folder owner and I am an admin) Can anybody tell me what to do? Thanks
asked 2024-03-27T03:18:21.71+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(249.60000000000002, 55.00000000000001%, 34%)' 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)
MMBot
0
Reputation points
commented 2024-03-29T09:52:51.1866667+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(160, 17%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYJ%3C/text%3E%3C/svg%3E)
Yanli Jiang - MSFT
22,111
Reputation points Microsoft Vendor
0 answers
Unable to view my certificate.
Despite following the provided steps to obtain my certification transcript, I have been unable to locate it within my account. Specifically, after logging in and navigating to the appropriate section, my transcript does not appear as expected. I have a…
asked 2024-03-27T14:12:00.4533333+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(233.6, 89%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYA%3C/text%3E%3C/svg%3E)
yodit araye
0
Reputation points
asked 2024-03-27T14:12:00.4533333+00:00
yodit araye
0
Reputation points
1 answer
Problem writing changes back to access database from gridcontrol
Hi I am populating a grid with data from an access database file (.accdb), and it works fine for showing my data. But I can't seem to get it to save changes from the grid back to the database file, my adapter.update(table) command completes without…
asked 2024-03-19T12:41:27.8566667+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, 0%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDR%3C/text%3E%3C/svg%3E)
Darren Rose
281
Reputation points
answered 2024-03-21T10:36:42.63+00:00
Darren Rose
281
Reputation points
1 answer
Locating local group policy editor settings for Microsoft Phone Link on Dell laptop running Windows 11."
DELL Windows 11 WarrioR Edition Windows 11 Pro Version 23H2 Installed on 2/21/2024 OS build 22635.3276 Experience Windows Feature Experience Pack 1000.22687.1000.0 (Device name DESKTOP-S3D2RRA Processor Intel(R) Core(TM) i7-10810U CPU @ 1.10GHz 1.61…
asked 2024-03-08T00:31:12.4433333+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, 2%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Jerika Morse
0
Reputation points
commented 2024-03-19T06:36:53.9233333+00:00
AllenLiu-MSFT
41,461
Reputation points Microsoft Vendor
0 answers
How to include more than two decimal places for percent format on Microsoft Access?
123.jpg For Microsoft Access, even though I set the Decimal Place parameter to 5 decimal places, Access rounds it to 2 decimal places. Is there any fix for this? Thank you.
asked 2024-03-18T16:10:41.7566667+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, 54%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECH%3C/text%3E%3C/svg%3E)
Cheng-Hsiang Lee
0
Reputation points
asked 2024-03-18T16:10:41.7566667+00:00
Cheng-Hsiang Lee
0
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…
asked 2023-05-22T13:31:44.04+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, 10%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBL%3C/text%3E%3C/svg%3E)
beheer Lorreine
20
Reputation points
commented 2024-03-18T13:43:20.85+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(230.39999999999998, 55.00000000000001%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVH%3C/text%3E%3C/svg%3E)
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,377 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
317 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.
841 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,034 questions
asked 2024-03-11T12:58:39.2+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(217.60000000000002, 76%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
crib bar
701
Reputation points
edited the question 2024-03-18T08:13:02.63+00:00
Emi Zhang-MSFT
22,796
Reputation points Microsoft Vendor
1 answer
"The application is disabled, and databases may not be created." this message pops up when i try to create a database. Ive been using access for homework and i don't no how to fix this. How would i enable it?
"The application is disabled, and databases may not be created." this message pops up when i try to create a database. Ive been using access for homework and i don't no how to fix this. How would i enable it?
asked 2024-03-12T14:24:11.9933333+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, 63%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDN%3C/text%3E%3C/svg%3E)
Daniela Noyola Olivares (Student)
0
Reputation points
answered 2024-03-12T14:43:52.02+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(256, 32%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Michael Taylor
49,356
Reputation points